Hi,

Is it possible to delete complete lines automaticaly?

I mean that for example, I want to delete all lines containing a
certain word or phrase (not a single cell or a find replace), say all
lines that contain the word ''blue'', can this be done or do I have to
scroll down the entire worksheet and manually delete the lines?

Thanks!


--
Simbad
------------------------------------------------------------------------
Simbad's Profile: http://www.excelforum.com/member.php...o&userid=27702
View this thread: http://www.excelforum.com/showthread...hreadid=472176