Hello everyone,
I need to write a vba macro that will do the following:
- I have a workbook with 36 sheets.
- In 33 of those sheets there is a simple formula in C1 which returns a numerical value.
- I need the macro to check cell C1 in each of those 33 sheets (so not the entire workbook), and if the value in that cell is zero it needs to hide that particular sheet before moving onto the next one.
I know this is doable as I've done it before, but I've been away from the game for a while now and can't remember how I did it last time!!
Thanks for your help!
Bookmarks