Remove Filters from certain columns

[dellmech]

This has got me stumped!

I have Filter icons in A17, B17, C17, D17, E17 which filters data from A18:E40

I want to remove the filter icons from B17 and D17. HOWEVER, if I insert a column after column A, the columns I want hidden move. So I have to name the columns.

So if I name column B ="RED" and column D ="BLUE"...does anyone know what VBA code I can use to keep the filter icons off these 2 columns?

Thanks for your help in advance!

 

[JoeMo]

Assuming your "icons" are filter dropdowns, try:

Range("RED").AutoFilter field:=1, Criteria1:=your criteria, visibledropdown:=False