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
