What is a function in VBA EXCEL witch finds a string like "not" in cell and then deletes a row with this cell?

From: "Marcin" <mar_male@xxxxx>
Date: 13 Nov 2005 05:57:16 -0800

Hello,
I have a problem with finding a string in a selection range and than
deletes row including this string. For example:
I have in column A:
________A________
1 | This is a cat |
2 | This is not a cat |
3 | This is not a dog |
4 | This is a fly |
...........................
40| This is not a horse |
41| etc.. |
I want to find cells which includs string "not" and delete a row with
this string.
How can I do this in a simply way?
Thanks for response.

.

Follow-Ups:
- Re: What is a function in VBA EXCEL witch finds a string like "not" in cell and then deletes a row with this cell?
  - From: David J. Braden
- Re: What is a function in VBA EXCEL witch finds a string like "not" in cell and then deletes a row with this cell?
  - From: Jerry W. Lewis

Prev by Date: How to connect two columns in Excel VBA??
Next by Date: Calculate,Copy,Paste
Previous by thread: How to connect two columns in Excel VBA??
Next by thread: Re: What is a function in VBA EXCEL witch finds a string like "not" in cell and then deletes a row with this cell?
Index(es):
- Date
- Thread

Relevant Pages

Re: compare column1 with column2
... Thanks for quick response. ... No this is string. ... myguess21's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29578 ... Prev by Date: ...
(microsoft.public.excel.programming)
Re: What is a function in VBA EXCEL witch finds a string like "not" in cell and then deletes a row w
... If this is over a lot of cells, ... Set rng = Union, where rng is a temp, and c is a cell with ... > I have a problem with finding a string in a selection range and than ... > deletes row including this string. ...
(comp.apps.spreadsheets)
=?iso-8859-1?q?Re:_Problem_with_Diagnostics.Process.GetProcess=ADes(String_machineName)?=
... Thank you for your response. ... servername... ... The string for the machine name is simply an S followed by some numbers ... Prev by Date: ...
(microsoft.public.dotnet.languages.vb)
Re: What is a function in VBA EXCEL witch finds a string like "not" in cell and then deletes a row w
... > I have a problem with finding a string in a selection range and than ... > deletes row including this string. ... Public Sub DeleteNot() ... Dim oCell As Range ...
(comp.lang.basic.visual.misc)
How to display quotes
... I am trying to output a " in a string, but I can't do it because a " is a ... "keyword" by the VB intellisense. ... response would be GREATLY appreciated! ... Prev by Date: ...
(microsoft.public.dotnet.languages.vb)