hello
I have a problem when I hide columns form c3:ag3 it should hide based on cell value is "TRUE" the cell value contain formula to show "TRUE" I no know if is that possible or not please guide me
thanks in advance
I have a problem when I hide columns form c3:ag3 it should hide based on cell value is "TRUE" the cell value contain formula to show "TRUE" I no know if is that possible or not please guide me
VBA Code:
Sub Hide_Columns_Containing_Value()
Dim c As Range
For Each c In Range("c3:ag3").Cells
If c.Value = "TRUE" Then
Columns(c.Column).EntireColumn.Hidden = True
End If
Next c
End Sub