Hi all, I'm trying to set named range as a constant in VBA, to allow me to recall the same range as an output target in different subs, without having to 'set' it in each module.
I have tried to declare it at the top of a module like this...
and get a "Compile Error : Constant expression required"
Any help really appreciated,
Thanks,
Joe.