View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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