Earl, Stan,
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.
Thanks,
Jim
"Earl Kiosterud" wrote:
Jim,
Since you said active cell, I presume you mean in VBA:
ActiveCell.Row or ActiveCell.Column
If you mean in a worksheet:
=ROW() OR COLUMN().
The above yields the row or column that the formula lives in.
--
Earl Kiosterud
www.smokeylake.com
Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------
"Jim Stuart" <Jim wrote in message
...
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.