CRayF,
Something different: Excel's Hidden Namespace:
http://www.cpearson.com/excel/hidden.htm

NickHK

"CRayF" wrote in message
...
I want to use a few variables in any Module I run in the current Workbook
without having to enter a Dim/Set command. These variables hold a value
that
does not change via the program. If a change is needed I would like to go
to
one place to update them. As well, I would like to give their value in the
same place.

I also know that they need to go on the top above any SUB() statement but
I
am uncertain which Module they belong in so that all other modules can
benefit from their value. I have Worksheet Sheet Modules and I see a
folder
with MODULES.
When I open this up, I have Module1-3. I figured these need to go in one
of
these Modules but am uncertain is it matters which one.

I also am uncertain of the exact syntax I need to use to enter this type
of
variable.

Each of these variables are currently define in the SUB() as follows:

Dim srcProgramDataInputWs As Worksheet
Dim srcProgramSummaryWs As Worksheet
Set srcProgramDataInputWs = Sheets("ProgramDataInput")
Set srcProgramSummaryWs = Sheets("ProgramSummary")