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.

Option Explicit
Option Base 1

Public Const wb as Workbook = ThisWorkbook
Public Const ws1 as Worksheet = wb.Sheets("Sheet1")
Public Const ws2 as Worksheet = wb.Sheets("Sheet2")
...

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.