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!