Forum Discussion
Ronald Seabaugh
Nov 17, 2018Copper Contributor
Hiding columns using VBA
I have a spreadsheet where the balance sheet and income summaries for each month of 2017 and 2018 are presented. To clarify, January 2017 is next to January 2018, February 2017 is next to February 2...
Willy Lau
Nov 17, 2018Iron Contributor
Just add this line before for-loop
Columns("D:AP").EntireColumn.Hidden = False
- Ronald SeabaughNov 17, 2018Copper ContributorVery simple fix and it works! Thank you very much!
- Lorenzo KimNov 17, 2018Bronze Contributorglad to hear it helped!