Thanks for your help. But here I mean to say is I want to search any of the worksheet containing the word 'vanessa', and then run the macro on that perticular sheet only.

I am a newbie for excel macros. So I dont know how to add flag and all.

Can you help?