How To Hide Columns In Excel Vba

by

How to Hide Columns in Excel VBA

To hide columns in Excel using VBA (Visual Basic for Applications), you can use the Columns property of the Worksheet object. Here’s an example:

Sub HideColumns()
    Dim ws As Worksheet
    Set ws = ThisWorkbook.Worksheets("Sheet1") ' Replace "Sheet1" with the name of your worksheet
    
    ' Hide columns B and C
    ws.Columns("B:C").Hidden = True
End Sub

In the example above, we declare a variable ws of type Worksheet and set it to refer to the worksheet where we want to hide the columns. You can replace “Sheet1” with the actual name of your worksheet.

We then use the Columns property and provide the range of columns we want to hide as a parameter. In this case, we specify “B:C” to hide columns B and C. You can modify the range to match your specific needs.

The Hidden property is set to True to hide the columns. If you want to unhide the columns, you can set the Hidden property to False.

You can run the macro by pressing Alt + F8 to open the “Macro” dialog, selecting the “HideColumns” macro, and clicking on the “Run” button.

Same cateogry post

Leave a comment