Case Statement with Multiple Conditions

Hello,

I'm trying to write a case statement for 4 different cases based on 2 worksheets and if they are visible or not. Ex.

Case Neither x or y visible
Do 1

Case Both x and y visible
Do 2

Case Sheet x visible
Do 3

Case Sheet y visible
Do 4

There will always be other sheets visible so I need the cases to be specific. I've tried multiple combinations and can't get them to work as describe above. Biggest problem is when both or neither are visible.

Thanks for the help.

Please Login or Register  to view this content.

Thanks to all that replied, I tried jindon and TMS's offering and they both worked as asked but it appears that I didn't ask the question correctly. I didn't realize that not visible (hidden) and non existent weren't the same thing. If the sheets are simply hidden all works well but if the sheets don't exists I get debugger. I am actually copying sheets form another workbook so sometimes one sheet exists and not the other or visa-versa, sometimes both exist and sometimes neither exists. Can you please help me restructure the code base on the existence of the sheet rather than visibility.

In that case

Please Login or Register  to view this content.

That did the trick jindon, many thanks!