Evening happy campers,
I am working on a sheet for a fellow Excel Forum user and need some input please!
Cell A1 contains the info "NAME 1" i want a code that will look for a sheet with the same name as the info in cell A1.
This name will change so it really needs to work on the info contained in A1.
Cheers all
galvinpaddy
This is only a hint:
Please Login or Register to view this content.
Ben Van Johnson
Hi ProntonLeah,
Can you explain how the code works? sorry but im lost - how does it look for the info in cell A1?
thanks
Last edited by galvinpaddy; 04-20-2012 at 05:13 PM.
The hint doesn't, I only meant for you to loop through the sheets in the workbook, testing each sheet name against the value in cell A1. You still have to specify the sheet containing the name to find, though....how does it look for the info in cell A1?
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks