Hi, I have been trying to write a do loop that goes through all my worksheets and either sets the print area of a worksheet or hides the worksheet from printing.
The script starts with an active cell on the coversheet and checks the number in it. If the number is 1-4 it will set a specific print area for a worksheet then increment on to the next cell. If the number is 0 it hides the sheet and moves on to the next cell. Each cell is should determine which sheets are hidden and which are not, kind of like going through a table of contents and hiding pages with a 0 next to them.
My difficulty is when i reference to a list of the worksheet names so that the script knows which sheet i want hidden. Can i somehow increment through the sheets until i reach a specific one, or is there just a slight language error in my script?