Hi,

I have an excel workbook which contains several excel worksheets. Now I have one macro for deleting perticular rows. But I want to run the macro only on the one of the worksheets in the workbook which contains the word "Vanessa". i.e, if any of the worksheets contains the data "Vanessa" then the delete rows macro should work for that perticular worksheet only. And not for any other worksheet.

Can ayone help?

Vanessa h