Hi,
I am currently struggling with a Private Sub Worksheet_Calculate() macro.
I have 3 areas of my worksheet that I wish to hide / unhide under different conditions.
Unfortunately I am struggling to get 3 'IF' statements into the one sub.
Here's what I have:
Please Login or Register to view this content.
I have also tried nesting the IF commands - but unfortunately only one of the conditions seem to work.
If anybody could shed some light on this I'd be really grateful as I've spent the past 2 days banging my head against a brick wall!
Bookmarks