View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Create Global Variables in a module

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)

"Bruce" wrote in message
...
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