View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default Cell references in VBA?

You can get it relative to the spreadsheet with Activecell.Left and .Top.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"MartinShort"
wrote in message
...

Any easy way to get the X and Y coords of the cell?


--
MartinShort

Software Tester
------------------------------------------------------------------------
MartinShort's Profile:

http://www.excelforum.com/member.php...o&userid=22034
View this thread: http://www.excelforum.com/showthread...hreadid=494191