Thread
:
How do I get the coordinates of the active cell in Excel?
View Single Post
#
5
Posted to microsoft.public.excel.misc
Stan Brown
external usenet poster
Posts: 524
How do I get the coordinates of the active cell in Excel?
Sun, 17 Jun 2007 11:30:00 -0700 from <?B?SmltIFN0dWFydA==?=
<Jim
:
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.
Do you want these in a VBA macro or in a worksheet? In a worksheet,
=ROW() is the current row number and =COLUMN() is the current column
number.
--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
Reply With Quote
Stan Brown
View Public Profile
Find all posts by Stan Brown