how to hide and unhide excel columns

1. Hide Columns: To hide columns using VBA, you can set the Hidden property of the entire column to True. Here’s an example that hides columns A to C:  Sub HideColumns()
   Columns(“A:C”).EntireColumn.Hidden = True
   End Sub

2. Unhide Columns: To unhide columns using VBA, you can set the Hidden property of the entire column to False. Here’s an example that unhides columns A to  C:Sub UnhideColumns()
   Columns(“A:C”).EntireColumn.Hidden = False
   End Sub

3. Hide Specific Columns: If you want to hide specific columns instead of a range, you can specify the column letters individually. For example, to hide columns B, D, and F:

Sub HideSpecificColumns()
Columns(“B”).EntireColumn.Hidden = True
Columns(“D”).EntireColumn.Hidden = True
Columns(“F”).EntireColumn.Hidden = True
End Sub

 

4. Unhide Specific Columns: To unhide specific columns, you can follow a similar approach by setting the Hidden property to False. For example, to unhide columns B, D, and F:

Sub UnhideSpecificColumns()
Columns(“B”).EntireColumn.Hidden = False
Columns(“D”).EntireColumn.Hidden = False
Columns(“F”).EntireColumn.Hidden = False
End Sub