How can I Delete rows were the first cell is blank?
I'd do it manually.
Select column A
edit|goto|special|blanks
edit|delete|entire row
(or rightclick on one of the selected blank cells and delete|entire row)
Mascot wrote:
HI,
I was wondering if there is Macro for this. I have a spreadsheet were
periodically
throughout column a the first cell is blank (the rest of the row
has Data but I don't need it. Does some one have a macro that will search for
these blank cells and delete the row?
Thanks
Mascot
--
Dave Peterson
|