If you declare a Public variable in a class module (for example a worksheet or ThisWorkbook module) then the variable may only be accessed as a member of that class. Therefore you must refer to it using syntax such as Sheet1.Variablename or ThisWorkbook.Variablename. If the variable is declared in a normal module, you may simply refer to it using its name from any other module in the workbook.

Ah. So, if I've understood you correctly, I have to create a new module in the workbook and declare all the variables as PUBLIC in that module and all other modules will recognize them.

I have already tried that. It seems to work. Let's see.

Best regards,

Officer_Bierschnitt

The reason for declaring them is a separate module is just hygiene. They are not specific to any other module (that's why they're public), and keeping them together lets you find them all at a glance. For someone trying to understand your code, it's a good place to start reading.

Public variables have their place, but should be used only after careful consideration of the alternatives. In general, they can make code harder to debug and maintain.

The only code I might include in that module is a routine that initializes those variables.