View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
reades
 
Posts: n/a
Default Identify current active cell

Thanks, but this is not quite what I want. If I clik the cursor in a random
cell, say G7, then "G7" will appear in the name box in the top left corner.
How do I get hold of "G7" I use the contents of this cell?


"Niek Otten" wrote:

Sorry, For some reason I thought you meant in VBA.
You already have a correct answer

--
Kind regards,

Niek Otten

"Niek Otten" wrote in message
...
Activecell.Row and Activell.Column

--
Kind regards,

Niek Otten

"reades" wrote in message
...
I would like to use the row & column of the currnet active cell pointed at
by
the cursor. How do I get to get this info?
Thanks
Rod