Hi there,
I am very new to VB coding in Excel so would really appreciate your expertise on this
I have a spreadsheet where I am hiding certain columns (all on the same worksheet) when a checkbox is ticked, I managed to get it working where there are consecutive columns using the below code:
Private Sub DomainRequestorColumns_Click()
If Range("C:S").EntireColumn.Hidden = True Then
Range("C:S").EntireColumn.Hidden = False
Else
Range("C:S").EntireColumn.Hidden = True
End If
End Sub
This works perfectly but I need to add a column AU and I can't for the life of me figure out how to do this?
Can you perhaps advise me on how I can do this please?
Thanks in advance,
Angela
Bookmarks