View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lillian[_3_] Lillian[_3_] is offline
external usenet poster
 
Posts: 7
Default delete record using Macro in excel spreed sheet

I have one excel spreed sheet, it about 30,000 records, I
need to deleted some of records, if columnsA
has "problem", the record will be delete, if rows is
space, the record will be delete, if ColumsA has "----",
the record will be delete, if column(F) has space, the
record will be delete.

How can I write the macro to delete those record, thanks
for the help.

Lillian