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

To get the row/column of the cell in which you're entering a formula, use
=row() or =column(). Note that the column will come back as a number (1
instead of A, etc).

"reades" wrote:

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