View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
 
Posts: 2,202
Default How do I get the coordinates of the active cell in Excel?

I am working in Excel and don't know much about Visual Basic or Macros.
Rick has given me a response which would probably help me if I did, but
the
fact is I can't make it work.

ROW() or COLUMN() just give the coordinates of the cell that the formula
is
written in.
I want to know the current coordinates of the cell that the "cursor" is
in.
The values should change as I use the arrows to move around the worksheet.


I think you will need to tell us more than you have about how you plan to
use this information. The reason your question, as stated so far, is
confusing is that you seem to want to "see" the active cell's row and column
while in the worksheet... but "active cell" is always being displayed in the
field located next to the formula bar, so you have to have something
"deeper" in mind with your question.... I think we are just having trouble
seeing what it is.

Rick