I have an address worksheet it has two columns. Name in column A and Adress
in column B
In the rows 1- 10,000 is the data , Some of the rows have no data ,
how can i delete all the blank rows without having to individually select
and delete each one .I have to have this done today and am totally loss on
how to do it . any help would be apreciated .
Is there a macro or something that can be used to delete all the blank rows?

Thanks
Steve