Hello,

I am using the below macro to hide an entire column:

HTML Code: 
I would like to do the same with a range:

E.g: hide unhide the range E43:K47 (using name manager the range = SCHEDULE2)

--> I have tried to replace Columns by range but it doesn't work

Thanks,
Graig