Question on my code: simple hide/unhide rows

Hello,
My macro works fine for the most part! Just need a small tweak, if somebody could be kind enough to take a look.
Cell A31 has the following four drop-down selections:
- Up to 5
- 6 to 10
- 11 to 20
- Over 20

Selecting 'Up to 5': Rows 37-41 will unhide
Selecting '6 to 10': Rows 37-46 will unhide
Selecting '11 to 20': Rows 37-56 will unhide
Selecting 'Over 20': Rows 37-64 will unhide

So my starting point is that rows 37-64 are hidden, and the appropriate number of rows will unhide based on a user selection.
The code I am using is below, and it works fine for unhiding.
The problem is that it won't dynamically update. E.g. if a user first selects '6 to 10', the required rows 37-46 will unhide fine. However if the user then changes the selection to 'up to 5', Excel won't revert to only showing rows 37-41.

This is my code:

Please Login or Register  to view this content.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #2 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

Try:

Please Login or Register  to view this content.

You unhide rows but you never re-hide the ones that should be hidden.

Also, you don't have to do this every time anything changes on the sheet. You just need to check whether A31 changed.

Try this:

Please Login or Register  to view this content.

By the way, it looks like 37-41 are always unhidden. Does some other process hide them?

You're welcome.



If you are satisfied with the solution(s) provided, please mark your 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


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.