How do you find out the cell address your in ? 1

[Jamie2002]

How do you write code to return the cell address your in at any one time.

Would you set-up a variable then set the variable to the cell address.....?


thanks.

 

[acron]

You can set a variable, but may not need to. You can just use ActiveCell.Address to get the address of the active cell.

AC

 

[SkipVought]

Hi,
ActiveCell.Address will return the address in A1 notation -- OK, but not as useful for programatically navigating around a spreadsheet.
So...

With ActiveCell
   lRow = .Row
   iCol = .Column
End With

and by incrimenting lRow and iCol, you can reference ANYWHERE on a sheet by way of...

Cells(lRow, iCol)

Just another alternative ;-) Skip,
metzgsk@voughtaircraft.com