• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 586
  • Last Modified:

VBA Excel - Hide All Columns But Column A

I need the VBA code that will hide all columns on the "Active" Sheet except for Column A, C and E.

Can anyone help?

0
CVGunx
Asked:
CVGunx
1 Solution
 
mvidasCommented:
CVG,

 ActiveSheet.Range("B:B,D:D,F:IV").EntireColumn.Hidden = True

Cheers!
Matt
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now