selecting multiple rows within a Macro
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 !!
.
|