Y
yosi_lb
Hi Everybody
How can I get the address of a cell whenever I click on it
thanks
How can I get the address of a cell whenever I click on it
thanks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
MartinW
Hi yosi,
Look at the top left of your screen, to the left of the formula bar.
It's called the name box.
HTH
Martin
Look at the top left of your screen, to the left of the formula bar.
It's called the name box.
HTH
Martin
C
CLR
Here's how in code............
Sub SelectedCellAddress()
MsgBox ActiveCell.address
End Sub
Vaya con Dios,
Chuck, CABGx3
Sub SelectedCellAddress()
MsgBox ActiveCell.address
End Sub
Vaya con Dios,
Chuck, CABGx3
B
Bob Phillips
'This is worksheet event code, which means that it needs to be
'placed in the appropriate worksheet code module, not a standard
'code module. To do this, right-click on the sheet tab, select
'the View Code option from the menu, and paste the code in.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
MsgBox Target.Address
End Sub
--
HTH
Bob Phillips
(there's no email, no snail mail, but somewhere should be gmail in my addy)
'placed in the appropriate worksheet code module, not a standard
'code module. To do this, right-click on the sheet tab, select
'the View Code option from the menu, and paste the code in.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
MsgBox Target.Address
End Sub
--
HTH
Bob Phillips
(there's no email, no snail mail, but somewhere should be gmail in my addy)
Z
Zack Barresse
More importantly, what do you want to do with it?
Regards,
Zack Barresse, aka firefytr
Regards,
Zack Barresse, aka firefytr