View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
guillermo.ht guillermo.ht is offline
external usenet poster
 
Posts: 1
Default delete entire row based on conditional test of column A

I have a spreadsheet with various invoice numbers in column A:
For example:
FC110107-002
PB110107-001
LV010707-001

I need a VBA macro that will delete delete an entire row if the LEFT 2
characters of a cell in column A have either: FC, PB, or GR

The default range of my data is usually rows 2 - 2000

I cannot seem to find other snippets of code that work for my needs, so any
help would be appreciated.