Hi there,
My main goal here is to push a button, and based on the contents of a cell will either show or hide a worksheet.
I have a macro that checks the contents of a variable on a worksheet for a #DIV/0! error, if there is one, performs an action, and if there isn't, performs an action.
My problem is I have a long list of these checks I wish to perform in one foul swoop, each with differing actions and reactions based on input. 30 in total. As I'm sure you can see, if there is a divisible by zero error I wish to hide the worksheet, and if there isn't, I wish to show it.
Long story short, can anyone help with this macro without coding 30 different IF statements?
Regards,
Chris
Bookmarks