Hello im new here and i was wondering if i could get some help on auto hiding coloums based on their color?
Would this code do what i want?
Sub hide_sheet2()
'hide empty tech rows
Dim rng, cells As Range
Set rng = Range("d2:gp2")
Application.ScreenUpdating = False
For Each cell In rng
If cell.Interior.Color = RGB(255, 255, 153) Then
cell.EntireColumn.Hidden = True
End If
Next cell
Application.ScreenUpdating = True
End Sub
Bookmarks