selecting multiple rows within a Macro
Hi,
Use : ActiveCell.CurrentRegion.Select -- JP http://www.solutionsvba.com "Eric Dreshfield" wrote in message ... How can I write the code to select multiple rows in a Macro ? I want the macro to mimic the following keystrokes: Ctrl-Shift-End to select a range of cells from where the cursor currently resides to the end of where data exists. I can't seem to figure out how to accomplish that. Thanks !! |
All times are GMT +1. The time now is 04:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com