Richard
Does it have to be a macro?
Sort the data by columnA and then the blanks will be at the bottom, then
select these rows and delete.
If you need a macro post back and we'll go that route
--
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