Hi all,
I had a problem similar to this before and you guys solved it, checked my last post and something is different and I cant solve this!
I have a userform located on Worksheet 3, to search a staff number on worksheet 6 ("Raw Data"). For some reason it works whilst on sheet 6 and also running through the VBA editor, but NOT on worksheet 3! I've tried defining the worksheets early on in the code, but nothing!
Any ideas?
I also need to have worksheet 6 hidden so people cant see it... So if there are any tips on how to hide then unhide a worksheet so that this search code can work that would be swell too!Please Login or Register to view this content.
Many thanks, one and all!
Bookmarks