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

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.

Please wrap your code in code tags.

Try

Please Login or Register  to view this content.

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.

try this

Please Login or Register  to view this content.