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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks