Bob,

Thanks....worked like a charm. For some reason I could
not get the macro recorder to give me anything but
absolute cell references.

Thanks for your help !!
Eric
-----Original Message-----
Eric,

Range(ActiveCell, ActiveCell.SpecialCells
(xlLastCell)).Select

basically created withe the macro recorder.

--

HTH

Bob Phillips

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


.