Hi all,

I have a problem and since I am not that great with VBA hope that someone can help me .

I would like to have a code that calls specific named range (e.g. "UK" or range "AM:BA") based on the cell value. So if e.g. $L$5=1 then show AM:BA in that sheet and hide everything else?

Any help is much appreciated!

Thank you!