Public Const Declaration of Workbooks, Worksheets, Ranges, etc.

[AlvaroSiza]

I would like to use the same variables in a number of procedures. Can I not declare those as Public and Constant prior to my procedures?

i.e.

Please Login or Register  to view this content.

I know that I can declare them here, but am trying to avoid (re)setting them over and over again within each procedure. Any help or guidance appreciated.

[shg]

Constants are just that -- they are assigned values based on expressions containing literals, other constants, and arithmetic operations -- that's it.

You can declare them as public variables and then initialize their values in some Init routine.

[hectop]

If you declare them Public, outside of any module they should be fine. Just ensure that you aren't (re-)declaring them anywhere else.