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

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.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200605/1

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

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

"mohd21uk via OfficeKB.com" wrote:

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.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200605/1

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

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


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Miguel Zapico" wrote in message ...
You have some examples with code in this page:
http://www.rondebruin.nl/delete.htm

"mohd21uk via OfficeKB.com" wrote:

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.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200605/1