Why wont my search function work when i change it from all sheets to active sheet?

I want this code to execute only for the data in worksheet 'User Sheet' from A2:A1001, however, i cant get it to work. It worked when i was running it for all sheets via the application function.
Please help

Please Login or Register  to view this content.

Thanks that worked!

Try this.
It worked for me and it found Rob on 3 sheets in column A

Please Login or Register  to view this content.

Ahhh never mind they beat me to the punch hehe

@ joshnathan

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.