Hiding multiple rows based on different target values

Hi all,

I have a worksheet within which the user selects whether an event is either; On-site (Bridport), Customer (UK) or Customer (International) and based on their choice different rows are hidden. There are 6 different events all with the 3 options and therefore different rows to hide.

I have the below code that works well for the first event, however, I'm having problems trying to extend it to the multiple events and options. Can anyone help?

The Target Cells are: B3, B17, B30, B44, B57, B70

Please Login or Register  to view this content.

Try this:

Please Login or Register  to view this content.

Hopefully I've not confused you.

Well, I guessed as much. But I couldn't second guess what you wanted for each range. So, some work for you to do there.

The first few lines show you how to eliminate the cells you are not interested in. Then you'll need a separate If block for each cell that gets through.

As it stands, for each option, you unhide ALL rows and hide the ones you want. You'll need to change that to unhide specific ranges for each cell (of interest) … you can do that at the beginning, before the Select Case block.

Untested

Please Login or Register  to view this content.

Sorry Folks Can I refer you back to the original post.


Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

@mehmetcik: there was a directive asking everyone (senior members) to leave moderating to the Moderators. So, that's what I do these days.

You're welcome. Thanks for the rep.

Thanks for adding the code tags.