View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 54
Default Delete rows if specific criteria not met.

I've done this but don't have the code at home. If you haven't gotten an
answer by tomorrow, I'll copy what I have then.

"SITCFanTN" wrote in message
...
I have a spreadsheet with 8 columns. I want to delete all rows that don't
have the text "Remittance" in column B. I would like to put the code in
an
existing macro. Is this very difficult? Thanks