Hide Columns AND Rows based on certain cell value

[Charleshb]

Hello, this will be a really simple one to resolve but I am trying to hide both Columns (E:H) and Rows (7:10) based on cell B2 showing as “Y”. I can do each one separately but they don’t seem to work together. Any help would be appreciated!

 

[Charleshb]

Yes, I copied the above in to the window for the relevant worksheet but nothing is changing when I change between Y and N

 

[Fluff]

Ok, put you cursor anywhere on this line of the code If Target.CountLarge > 1 Then Exit Sub& press F9
That line should then have a brown background. If you then change the value in B2 does the editor open up with line highlighted yellow?

 

[Charleshb]

Ok, it is now working. Thanks so much for your help - i will still be reading up though

 

[Fluff]

You're welcome & thanks for the feedback.