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

's Computer Specifications

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

's Computer Specifications

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
>

's Computer Specifications

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" <(E-Mail Removed)> wrote in message news:5A77068F-7002-453D-B1E9-(E-Mail Removed)...
> 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
>>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how to delete a line in VS2005 that starts with some characters	puzzlecracker	Microsoft Dot NET Framework	1	8th Oct 2008 04:53 PM
delete rows where value of cell "starts with" something	tahrah	Microsoft Excel Programming	7	15th Jan 2007 10:05 PM
Delete file if it starts with a number	Michael Smith	Microsoft Excel Programming	3	23rd Feb 2006 05:09 PM
how do I DELETE the choose profile box when MS outlook starts	=?Utf-8?B?Zm90bw==?=	Microsoft Outlook Discussion	1	11th Oct 2005 09:39 PM
If (starts with ', then delete the ')	michael_mcclellan@hotmail.com	Microsoft Excel Programming	9	17th Dec 2004 06:48 PM