Hi
I have a worksheet change event that looks at a range of 11 cells
If any of those changed, then there are 11 If/Else statements under it to either hide or unhide rows on a different tab.
My question is, do I have to do this 11 times or is there a cleaner/better way?
I've named all the various ranges in a similar fashion.
Please Login or Register to view this content.
Last edited by ker9; 08-28-2015 at 04:20 PM.
Post all the code, please.
Click the * Add Reputation button in the lower left hand corner of this post to say thanks.
Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.
That was almost all the code - all 11 would be about the same. I didn't set them all up wondering if there was something better.
Please Login or Register to view this content.
Hi ker9
Not tested...
Please Login or Register to view this content.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
Hi jaslake - I appreciate your help, but I'm not sure I understand why that is any better than the 11 If statements. I still have to set up 11 sets. Thank you!
Maybe:
Please Login or Register to view this content.
If you are happy with my response please click the * in the lower left of my post.
Please Login or Register to view this content.
Last edited by AlphaFrog; 08-28-2015 at 03:55 PM.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Hi ker9
Not...only 2
This sets up the first set
This sets up the secondPlease Login or Register to view this content.
Please Login or Register to view this content.
stnkynts - works beautifully!! Thank you!
AlphaFrog - I get a "Range of Object" error on the 2nd If statement
Please Login or Register to view this content.
Okay, that's cool I wanted to make sure what you had followed the complete pattern of what you were doing. If there was more I wanted to see what you wrote.That was almost all the code - all 11 would be about the same. I didn't set them all up wondering if there was something better.
Sry, I edited it above in post #7Originally Posted by ker9
AlphaFrog - I get a "Range of Object" error on the 2nd If statement
Please Login or Register to view this content.
jaslake - I get it now - thanks!
or maybe so (using a code from AlphaFrog)
editedPlease Login or Register to view this content.
it would be better
Please Login or Register to view this content.
Last edited by nilem; 08-28-2015 at 04:20 PM.
AlphaFrog - working perfectly now.
Now my only problem is which one to choose
Thank you all very, very much and I learned quite a bit, too!
nilem- works great, too! (but I understand it the least, I'll think on it)
nilem - works great, too! (but I understand it the least so I'll need to think on it)
Why do you care whether it's hidden or not since you're going to hide it anyway?
/AlphaFrog
/NilemPlease Login or Register to view this content.
Please Login or Register to view this content.
Last edited by xladept; 08-28-2015 at 04:37 PM.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks