Greetings,
Thanks to the forum's help, I am using the following code to hide specific worksheet columns. However, I am actually needing to delete all the columns that do not equal the vArray range.
![]()
Sub rfd_Column_Hide() Dim vArray, vRng vArray = ThisWorkbook.Worksheets("SetUp_Page").Range("AU12:AU27").Value Columns("A:CK").EntireColumn.Hidden = True For Each vRng In vArray Range(vRng).EntireColumn.Hidden = False Next vRng End Sub
Bookmarks