VBA Help: delete whole row if the cell does not contain string "*"

[zenzen]

Hi all,

I am only a beginner in VBA. I have come across the problem where I
have a range of data in excel. In each rows, I want to check if the
cell in that row does contain a string "*".

If the row where the cell does not contain string "*" I want to delete
the whole row.


I am having problem in figure out how to relate each cell search if it
contains a string"*".

Can anyone give me some idea/help?

Thanks

ZenZen

 

[Paul W Smith]

Pseudo-code:

Loop down the column of the cells you are checking, something like...

Do
{Check Deletion criteria}
move one row down
Loop until end criteria

If the deletion criteria matches, move to the next row and then delete the
previous.

Checkcell.offset(-1,0).entirerow.delete

HTH

 

[Gary Keramidas]

when you need to delete a row, it's better to start at the last row and work
your way up.

 

[Ron de Bruin]

I have a few examples here
http://www.rondebruin.nl/delete.htm

You can change the = for <> to do what you want

 

[zenzen]

Thank you everyone!

I now have some idea and will try it out