VBA- Hide cells if X

[bloodybrit90]

Hey guys,

I need a create a horizontal filter, however this does not seem possible with excel 2010. Instead I have a formula in Cells C27:AF27 that returns "Y" if I want to keep the column and "X" if I want to hide the column. How can I hide theses columns with VBA if C27:AF27 are "X"

Any help would be great.

 

[VoG]

Try

Sub test()
Dim i As lomg
For i = 3 To 32
    Columns(i).Hidden = Cells(27, i).Value = "X"
Next i
End Sub

 

[bloodybrit90]

I received a compile error; user defined type not defined.

 

[VoG]

Sorry, typo

Sub test()
Dim i As Long
For i = 3 To 32
    Columns(i).Hidden = Cells(27, i).Value = "X"
Next i
End Sub

 

[bloodybrit90]

Worked Perfect. Thanks