Hi Im trying to select a range with a macro...
I would like to select the range from the active cell and X rows down.
How can I do this?
My code:
Myrows = Selection.rows.count
MST = Activecell.address
Range(& ActiveCell & " : " & Myrows )
However this gives me, i.e. B3:53
How can I get the Column letter before Myrows?
--
Ctech
------------------------------------------------------------------------
Ctech's Profile:
http://www.excelforum.com/member.php...o&userid=27745
View this thread:
http://www.excelforum.com/showthread...hreadid=480983