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