Hi I am new to VBa and trying to have a button that toggles hide/show certain columns at once.
The columns I would like otthide are AL, BD-BE-BF-BG
Sub FV_Click()
If Worksheets("Overview").Range("AL:AL").EntireRow.Hidden = True Then
Worksheets("Overview").Range("AL:AL").EntireRow.Hidden = False
Else
Worksheets("Overview").Range("AL:AL").EntireRow.Hidden = True
End If
End Sub
I did this to hide AL as a start, it works but when I paste that 4 more times replacing AL for BD, then BE, etc.. the macro implodes my spreadsheet. Clearly this isn't efficient or proper way
Can anyone suggest me a code to Hide/Show those columns upon click of a button.
Thanks in advance!
Bookmarks