From the Remarks section of the help files for the Const Statement...

"You can't use variables, user-defined functions, or
intrinsic Visual Basic functions (such as Chr) in
expressions assigned to constants."

--
Rick (MVP - Excel)


"slarbie" wrote in message
...
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!