Mark a range from activecell
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 |
All times are GMT +1. The time now is 08:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com