I am currently using this code.
Columns("J:W").EntireColumn.Hidden = True
Columns("J:W").EntireColumn.Hidden = False
While I've been working on my workbook, I've needed to change the column references above several times because I keep changing the layout of my design.
I am hoping someone could revise both of my macro's, so that where is says "J:W" - the code then looks to a variable up ?above? that holds the value (IE: J:W)
Does that make sense?
Thank you in advance for your help!