Hi Everyone,
Noob here
I have a worksheet that I am trying to make a portion of it (say columns J to Q) unhide when a particular cell (say A1) has content.
When the content of cell A1 is deleted or not there to begin with, Columns J to Q should hide.
My pseudo-code:
IF A1 is blank Then
Columns (J:Q).Hidden = True
Else IF A1 is not blank Then
Columns (J:Q).Hidden = False
This Macro needs to be triggered everytime A1 is altered.
I have been sweeping sites and YT videos trying to figure this out and have tried writing differing codes for hours but can't get anywhere.
Thanks In advance
Bookmarks