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.