View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Earl Kiosterud Earl Kiosterud is offline
external usenet poster
 
Posts: 611
Default How do I get the coordinates of the active cell in Excel?

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.