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:
I have a dynamic named range called values_column_hide that at the moment covers Sheets("column_hide_settings").Range("B2:B30").Please Login or Register to view this content.
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
Bookmarks