How to Hide and Show a Column in Excel with VBA

Опубликовано: 21 Октябрь 2024
на канале: Alex C

38,047

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

Handy Excel Resources
https://amzn.to/3gFx7s1 - Excel Formulas & Functions For Dummies 5th Edition
https://amzn.to/3sYnuH6 - Microsoft Excel 2019 VBA and Macros
https://amzn.to/2PqXhU0 - MICROSOFT EXCEL VBA AND MACROS FOR BEGINNERS:
https://amzn.to/3xtsLtM - Microsoft Excel VBA Programming for the Absolute Beginner
https://amzn.to/3xwkEg0 - Excel 2019 Bible
https://amzn.to/3aJEHxW - EXCEL 2020 FOR BEGINNERS

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