Create Global Variables in a module

B

Bruce

Is it possible to set variables for access to all sub routines and functions within a module?

eg. pathB = ThisWorkbook.Path is refer to this in many sub routines

Bruce
 
B

Bob Phillips

Bruce,

Declare the variable outside of a macro, at the start of the module. They
can then be set/read from any procedure in that module.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top