Thread: How do I get the coordinates of the active cell in Excel?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Jim Stuart[_2_] Jim Stuart[_2_] is offline
external usenet poster
  
Posts: 4
Default How do I get the coordinates of the active cell in Excel?

Rick,
Looks helpful. Now I have to figure out how to write a macro.
Thanks,
Jim

"Rick Rothstein (MVP - VB)" wrote:

I want to find the row and column numbers of the active cell
so that I can use them as variables in an Excel worksheet.

I presume you mean in a macro...

TheActiveRow = ActiveCell.Row

TheActiveColumn = ActiveCell.Column

Rick

Reply With QuoteReply With Quote