how to get the address of the ceected cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

yosi_lb - 27 Jan 2007 11:30 GMT

Hi Everybody

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

thanks

Reply to this Message

MartinW - 27 Jan 2007 12:01 GMT

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

Reply to this Message

CLR - 27 Jan 2007 15:40 GMT

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

Sub SelectedCellAddress()
MsgBox ActiveCell.address
End Sub

Vaya con Dios,
Chuck, CABGx3

> Hi Everybody
>
> How can I get the address of a cell whenever I click on it
>
> thanks

Reply to this Message

Bob Phillips - 27 Jan 2007 16:38 GMT

'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

Signature

HTH

Bob Phillips

(there's no email, no snail mail, but somewhere should be gmail in my addy)

> Hi Everybody
>
> How can I get the address of a cell whenever I click on it
>
> thanks

Reply to this Message

Zack Barresse - 27 Jan 2007 19:29 GMT

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

Regards,
Zack Barresse, aka firefytr

> Hi Everybody
>
> How can I get the address of a cell whenever I click on it
>
> thanks

Reply to this Message