Macro to Hide Columns based on Multiple Selection (Drop-down Box)

[Excel-lent7]

Here is my situation,

I need to hide Columns based on Multiple Selected Criteria from Combo Box as follows:
ComboBox is in A1, (ComboBox Contains 15 Counties from which I can select as many as needed). Every column contains one county name or multiple counties names in the same cell and across row 4. Ex: D4 (Brevard), E4 (Brevard, Citrus), F4 (Marion), G4 (Polk,Citrus,Volusia) etc.
I need the Macro to hide the Columns of Counties not selected in dropdown box, if the county selected in drop down box is found within the cell, it must remain visible.

I've found similar cases on the net, but not quite what i need.

Hope anyone can help,

Thanks in advance.

 

[mccolef]

Hi there.

I have a similar problem - just wondering if you ever found a way of doing this ?

Thanks

Feilim