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?
Bookmarks