Hi crew,
In cell A3 (actually is a merged range of A3:D3), there is drop down list of 12 values, in which I have this list value of "Consolidated",
Is there a way to run a macro that hides row 15 if the value "Consolidated" is selected? And unhide the row if any other value is selected?
Thanks,
Last edited by ron2k_1; 01-21-2011 at 10:40 AM.
Ron
Knowledge is knowing that a tomato and pepper are fruits. Wisdom is knowing whether to put these in a fruit salad
Kindly
[1] Use code tags. Place "[code]" before the first line of code and "[/code"]" after the last line of code. Exclude quotation marks
[2] Mark your post [SOLVED] if it has been answered satisfactorily by editing your original post in advanced mode.
[3] Thank (using the little scale) those that provided useful help; its nice and its very well appreciated
would something like this work guys?
Please Login or Register to view this content.
Perhaps:
Please Login or Register to view this content.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
This works for me.
Please Login or Register to view this content.
Last edited by DonkeyOte; 01-21-2011 at 07:34 AM. Reason: CODE rather than QUOTE tags please
The Boosh! You are a legend! Thank you for this piece of code!!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks