Thread: To Delete the specific rows when blank is found on column A
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ddiicc ddiicc is offline
external usenet poster
  
Posts: 42
Default To Delete the specific rows when blank is found on column A
Hi everyone,

Yesterday, Norman gave mi the solution to my subject stated the above.

Columns("A:A").SpecialCells(xlBlanks).EntireRow.De lete

The writings stated the above works... but I am facing another problem which
is if when worksheet happens to be empty with no datas, so how am I gonna
continue from there?? cos the writings above only works if there is datas in
the worksheet.

AJ
Reply With QuoteReply With Quote