Hello, I am trying to hide/unhide sheets based on whether or not there is text in specific cells. I can get the first command to work, but cannot get the remaining statements to execute. Here is a sample of the first 3 [out of 40 statements] from my code:
Thank you,
Please Login or Register to view this content.
Aaron
I think you may have more success with just one change sub and using a Select Case statement...
Thank you for the reply. I am a novice at VBA. Am I on the right track here? And if so, how do I get it to continue to the next hide/unhide based on contents of next cell/range in the same sheet?
Please Login or Register to view this content.
Last edited by aksnave; 03-23-2012 at 06:12 PM. Reason: missing ')'
Select case may not be the best way. Try adapting this...
Please Login or Register to view this content.
Thank you dangelor...that is super clean! I adjusted it to below so the sheet is hidden if cell is empty and it works fantastic!
Please Login or Register to view this content.
Glad it works for you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks