View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ir26121973 ir26121973 is offline
external usenet poster
 
Posts: 45
Default Delete Blank Rows

Hi,

Wonder if someone could help me please.

I have a spreadsheet with various rows of data in. There are however rows
that are blank.

Can anyone point me in the right direction as to how I may write a macro
that searches from row 1 to 65536 and checks that if the cells in columns A:Z
are blank it deletes that row.

Thanks very much

Chris