Hide Columns

[mathsbeauty]

Hello! I am new here. I am learning macros in excel. I am stuck with the following situation. I need macro which:
i) Shows column C and D.
ii) Shows column F but those cells which contain "NO" in column F are not shown.
iii) All other columns are hidden.
Thus the problem is to hide all columns except C, D and F and to hide those cells in F which contains "NO".

I hope to get some help from experts. I will be really thankful for the help that I may get.

 

[mathsbeauty]

Hello! This code seems to be working for my problem:

Sub Macro1()
    Cells.EntireColumn.Hidden = True
    Range("C:D").EntireColumn.Hidden = False
    Range("F:F").EntireColumn.Hidden = False
    Columns("F:F").Select
    Selection.AutoFilter
    ActiveSheet.Range("F:F").AutoFilter Field:=1, Criteria1:="<>NO"
    Application.Goto [a1]
End Sub

 

[jasonb75]

Had :F missing in the suggested code, that's why it didn't work,

Sub test()
    Cells.EntireColumn.Hidden = True
    Range("C:D", "F:F").EntireColumn.Hidden = False
    ActiveSheet.[F1].AutoFilter Field:=1, Criteria1:="<>no"
    Application.Goto [a1]
End Sub

 

[mathsbeauty]

Hello! Your code works, but instead of autofiltering column F it autofilters column C. Thanks for all your efforts.