macro to hide rows

[EdMac]

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

[mudraker]

Ed

Try this code -Maunual running code requied .eg attached to a button

Please Login or Register  to view this content.

To have macro run when value in C35 changes
Copy the following macro
Right click on sheet name tab
Select View Code
Paste copied macro into VB Sheet Module displayed
Return to Excel & test by changing C35

Please Login or Register  to view this content.

[EdMac]

Mudraker,

That is ideal - thanks very much

Ed