Hello everyone!
Can you please help me fix this formula.
The idea of the formula is to hide specific columns in the sheet depending on the cell value. It also unprotects the sheet and when its done protects it again. Everything is ok except that when i type 3 it hides only column H and not H,I and J, when i type 2 it hides only I and not I and J and when i type 1 it hides J just as it should.
If there's a way to shorten the code i'll be happyPlease Login or Register to view this content.
Thank you in advance!
Bookmarks