how to get the address of the ceected cell

[yosi_lb]

Hi Everybody

How can I get the address of a cell whenever I click on it

thanks

 

[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

 

[CLR]

Here's how in code............

Sub SelectedCellAddress()
MsgBox ActiveCell.address
End Sub

Vaya con Dios,
Chuck, CABGx3

 

[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)

 

[Zack Barresse]

More importantly, what do you want to do with it?

Regards,
Zack Barresse, aka firefytr