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:
Cloumns to hide
C:E
J:K
S:T
AB:AC
AK:AL
AT:AU
BC:BD
BL:BM
BU:BV
CD:CE
CM:CN
CV:CW
DE:DF
DN:DO
DW:DX
EF:EG
EO:EP
EX:EY
FG:FH
FP:FQ
FY:FZ
GH:GI
GQ:GR
GZ:HA
HI:HJ
HR:HS
IA:IB
IJ:IK
IS:IT
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
Bookmarks