problem hide specific columns based on cell value(formula)

[MKLAQ]

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

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

thanks in advance

 

[Fluff]

Try without the quotes

 If c.Value = TRUE Then

 

[Joe4]

Are the values TEXT values of "True" or Boolean values of TRUE?
If Boolean, do not use quotes around the word TRUE, i.e.

If c.Value = TRUE Then

EDIT: Too slow! Fluff beat me to the punch!

 

[MKLAQ]

ahh ! that's because the formula
many thanks guys for your assistance

 

[Fluff]

Glad we could help & thanks for the feedback.