Delete row if cell starts with ...........

[mohd21uk via OfficeKB.com]

I have a couple of values in Column 1 where there are values that start with
PJR. I would like to delete the whole row if a cell contains a value that
starts with PJR. I would be grateful if you could provide me a Macro that
would do just this.

Many Thanks.

 

[Guest]

You have some examples with code in this page:
http://www.rondebruin.nl/delete.htm

 

[Ron de Bruin]

Another option is to use EasyFilter to do this
http://www.rondebruin.nl/easyfilter.htm