Hi

See
http://www.rondebruin.nl/delete.htm


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


"herve" wrote in message
...

Hello all,

In an XL file, in cell C10 to C200, i have a text (PNL, LP or CP).
I would like to delete all rows where, in column C i have CP.

does anyone know a macro to perform that task ?

Regards

H.


--
herve
------------------------------------------------------------------------
herve's Profile: http://www.excelforum.com/member.php...o&userid=27314
View this thread: http://www.excelforum.com/showthread...hreadid=473431