Find delete
 

Hi, in a macro I would like to find any row that contain a certain words if
find delete the entire row and shift up.

Thanks

Hi Jean-Francois

Do you want to check the whole row or one column ?

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



"Jean-Francois" wrote in message ...
Hi, in a macro I would like to find any row that contain a certain words if
find delete the entire row and shift up.

Thanks

Only one column

"Ron de Bruin" wrote:

Hi Jean-Francois

Do you want to check the whole row or one column ?

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



"Jean-Francois" wrote in message ...
Hi, in a macro I would like to find any row that contain a certain words if
find delete the entire row and shift up.

Thanks

Hi Hi Jean-Francois

Check out this page
http://www.rondebruin.nl/delete.htm

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



"Jean-Francois" wrote in message ...
Only one column

"Ron de Bruin" wrote:

Hi Jean-Francois

Do you want to check the whole row or one column ?

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



"Jean-Francois" wrote in message
...
Hi, in a macro I would like to find any row that contain a certain words if
find delete the entire row and shift up.

Thanks