I am working on a spreadsheet for my company that allows loan officers to view information for each investor we work with.
I am currently using this code -
Private Sub CheckBox4_Click()
[j:j].EntireColumn.Hidden = CheckBox4
[k:m].EntireColumn.Hidden = False
[n:bc].EntireColumn.Hidden = CheckBox4
The above code represents one investor we work with. It closes the column(s) before, and the column(s) after and allows the column to be looked at to stay visible.
What I am after is how do I allow for multiple columns to be viewed at the same time using the code above.
Any help would be appreciated.
Thank you. Dave