Drop down with worksheet_change

[jwagman1]

So I am trying to use the answer to a drop down to hide a range of rows if a certain answer is selected. Here is the code Ive pieced together but it may not be right at all.. Help please?

Please Login or Register  to view this content.

[tigeravatar]

jwagman1,

This code goes in the "L&M" sheet code module:

Please Login or Register  to view this content.

[jwagman1]

Works like a charm!! Thanks much for the help. You rock!

[tigeravatar]

You're very welcome

If that takes of your need, please mark this thread as solved.
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save