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 !!