Thread: Address
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Address


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)

"John Collins" wrote in message
...
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.