Address

  • Thread starter Thread starter John Collins
  • Start date Start date
J

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.
 
One way:

If ActiveCell.Address(False, False) = "A1" Then
Msgbox "Column: " & ActiveCell.Column & vbNewLine & _
"Row: " & ActiveCell.Row & vbNewLine & _
"Address: " & ActiveCell.Address
End If
 
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)
 
Back
Top