Multiple Macros to hide rows dependent on Yes/No answer on the same sheet

[fatbloke83]

Hi All,

First of all thanks for all of the help posted on this forum, normally i can find the answer to my questions without having to post.

I have a situation where i am using a macro to hide rows dependent on a yes/no answer from a list via validation.

The formula i found on here is as below and works great:

Please Login or Register  to view this content.

I now need to run the same macro but for several other yes/no cells e.g. G6,G8 and G9 and if they are also "no" responses i need it to hide different rows. I think there will be 6/7 of these formulas in the end.

I thought i could simply copy the marco again after the first macro but that doesnt seem to work, i am sure i have missed something really obvious here, but would welcome anybodys advice on how to correct this issue.

Many thanks in advance for your help.

[npamcpp]

Please wrap your code in code tags.

Try

Please Login or Register  to view this content.

[arlu1201]

Fatbloke83,

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature.

[fatbloke83]

Thanks Npamcpp, but that isnt quite what i am looking to acheive, apologies i dont think i have explain myself very well. I need the following to be accomplished:

If G5 = "No" hide rows 56:61
If G6 = "No" hide rows 63:71
If G7 = "No" hide rows 94:102
If G8 = "No" hide rows 104:109
If G9 = "No" hide rows 73:92

All of the above need to work independent of each other as there can be numerous combinations of yes/no.

Thanks again for your prompt response those, and apologies for the lack of code wraps.

Cheers

Mark

[john55]

try this

Please Login or Register  to view this content.