Additionally, if you want the data back as it was pre-sort then run an index
down a blank column by entering a 1 in the top cell, 2 in the next, then
select both and double click the 'fill handle'. (Square in bottom right of
second cell)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Richard" wrote in message
...
Using MS Excel 2000.
Help creating a macro please.

I need to search the range A1:A10000 and if the cell is blank I want to
delete the entire row.

Thanks in advance.
--
Richard