MrExcel Publishing
Your One Stop for Excel Tips & Solutions

ActiveCell


Posted by Geoff on June 21, 2000 9:05 AM

Using VBA, how do I get the coordinates of the active cell? Like let's say the active cell is "B4", where do I get that from? I know there is an ActiveCell property but I can't seem to extract the location from it, only the value in that cell. Thanks for any help.


Posted by mads on June 21, 0100 9:35 AM


For the relative cell ref :-
ActiveCell.Address(False, False)

For the absolute cell ref :-
ActiveCell.Address

mads