Hide Rows based on cell value

[mjg060468]

Hi,

Hope someone can help

I am trying to work out, how to hide rows 57:63 in a worksheet named 'Nov 2013' if cell M2 = 1 in worksheet named 'Data Input'

Probably really easy but I am struggling to find an answer

Regards

[ragulduy]

Please Login or Register  to view this content.

I think

[mjg060468]

Please Login or Register  to view this content.

I think

Sorry to be a pain but where do I put it as if I put this as it is into vba, nothing happens

[ragulduy]

If you want it as a normal "macro" then:

Please Login or Register  to view this content.

how are you planning on using it?

[mjg060468]

Have tried it and error message comes up. I have tried to hide the rows seperately and get the error message "Cannot shift objects off sheet" Seems to be because I have formulas in some of the cells I wish to hide