Trustworthy, have a look here for some code by Chip Pearson to do it

http://makeashorterlink.com/?T2E221D8B

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Trustworthy" wrote in message
...
I receive a daily spreadsheet that has unnecessay rows of information
scattered throughout the sheet. To delete them, I have to hold down the
control key, left click on entire row, then select delete. To avoid
inadvertently clicking in a cell and having to start over again, I delete
every so often. My question is... does anybody know of away to undo the
last
click without losing all the other rows that were previously highlighted?