How to Hide and Show a Column in Excel with VBA

This video shows how to hide or show a column in Excel using a VBA Macro in Microsoft Excel.

Handy Excel Resources

As an Amazon Associate, I earn from qualifying purchases. Product prices and availability are subject to change.

Sub HideColumn()
Sheets("Sheet1").Columns("I:J").EntireColumn.Hidden = True
End Sub

Sub ShowColumn()
Sheets("Sheet1").Columns("I:J").EntireColumn.Hidden = False
End Sub

[stwin]

Great video, worked perfectly for me. Love that your video is short and to the point!

[yyGrifHD]

Hey Alex, is it possible to do this with grouping rather than hiding?

[abwkenn]

I want to hide columns with protect password, possible to do this protection ?