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

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

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


"zenzen" wrote in message
...

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


--
zenzen
------------------------------------------------------------------------
zenzen's Profile: http://www.excelforum.com/member.php...o&userid=30224
View this thread: http://www.excelforum.com/showthread...hreadid=499014