Try
![]()
Option Explicit Sub toggleColumns() With ActiveSheet.Range("C:C,I:I,S:S,X:X") .EntireColumn.Hidden = Not .EntireColumn.Hidden End With End Sub
Try
![]()
Option Explicit Sub toggleColumns() With ActiveSheet.Range("C:C,I:I,S:S,X:X") .EntireColumn.Hidden = Not .EntireColumn.Hidden End With End Sub
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks