I have some VBA code i wish to run a search on three different worksheets for a value but I can't figure out how to search more than one worksheet. here is the code I have so far.
On the line With Sheets("plant").Range("A1:A5000") I need to specify the range to be ("A1:A5000") but on three worksheets.
Please Login or Register to view this content.
Please help, I am only new to this and it's driving me mad!
Mr_Mango
Last edited by mr_mango81; 04-12-2013 at 01:57 AM.
Hi, Mr_Mango ,
maybe like this:
Ciao,Please Login or Register to view this content.
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Holger,
You are a Champion, thats works perfectly! Thankyou very much for your effort!
Mr_Mango
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks