Hi,

I am looking for a macro to achieve the following

Based on the value of Cell C35 either "yes", "no" or ""

if C35="Yes" or ""

Hide rows 37:61

else if C35="No" unhide rows 37:61

It should be possible to toggle between the two conditions

Grateful any help

Ed