VBA. Hide columns based on values in namd range.

[rain4u]

Hi
What would be the most efficient code to hide quite few columns based on values in certain named range.

E.g. below is values in column B:

Please Login or Register  to view this content.

I have a dynamic named range called values_column_hide that at the moment covers Sheets("column_hide_settings").Range("B2:B30").
Right, any ideas?

Any help is always greatly appreciated.


EDIT. Just to let you know I would switch to the relevant sheet before running the code.
Cheers

[mrice]

Try

Please Login or Register  to view this content.

[mrice]

Even easier on reflection

Please Login or Register  to view this content.

[rain4u]

Works perfectly. Thank you.