Public Range Constant - how do I?
If the Public range constant won't work, why not use a Public constant String
to hold the Range Address ??
--
Gary''s Student - gsnu200839
"slarbie" wrote:
In all the modules/procedures of my project, I'd like to be able to refer to
a specific named range as a constant. I imagined this:
Public const MyRange as Range = Range("MyRange")
at the top of a module, but it doesn't work. Can someone help with the
right way to do what I'm trying to get at here? Thanks!
|