I'd love to know what is stopping you from sorting this?

Regards
Robert McCurdy

"If you can't, use Word"

"RC" wrote in message ...
I have a worksheet where I want to delete alternate rows. i.e. rows
1,3,5,7,9.......... because they contain no data. Currently I am holding the
control key and selecting every other row, then using the delete row toolbar
button. However I have many worksheets to do.
I thought I'd create a macro to automatically hilight alternate rows and
then just use the delete row button. I did create that macro but when using
it, instead of hilighting the alternate rows from where my cursor is inserted
it just hilights the same rows as when the macro was created (i.e. the wrong
rows).
How can I set something up that allows me to hilight alternate rows from
where I place my cursor.


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.736 / Virus Database: 490 - Release Date: 09/08/2004