Wednesday 28 March 2012

How to Hide and Show a Column in Excel with VBA

Title:
How to Hide and Show a Column in Excel with VBA


Video:


Description:This video shows how to hide or show a column in Excel using a VBA Macro in Microsoft Excel. Sub HideColumn() Sheets("Sheet1").Columns("I:J").EntireColumn.Hidden = True End Sub Sub ShowColumn() Sheets("Sheet1").Columns("I:J").EntireColumn.Hidden = False End Sub

Published:
28/Mar/2012

No comments:

Post a Comment