Address

[John Collins]

Hi
The question is: How to find if a specific cell has been selected and show
its Column, Row and Address?

Thank for your time.

 

[J.E. McGimpsey]

One way:

If ActiveCell.Address(False, False) = "A1" Then
Msgbox "Column: " & ActiveCell.Column & vbNewLine & _
"Row: " & ActiveCell.Row & vbNewLine & _
"Address: " & ActiveCell.Address
End If

 

[Bob Phillips]

If not intersect(Activecell, Range("A1:H100")) Then
Msgbox ACtivecell.Address
End If

Untested, but should give some leads.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)