f5gotospecial blanksthen delete

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"GEM" wrote in message
...
I have a spreadsheet which has one row with data and one row blank, it's
about 1000 rows down, is there any way I can delete the blank rows. If I
apply autofilter it won't catch the other rows after the first one, is
there
any way to delete all the blank rows???