View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
K Dales[_2_] K Dales[_2_] is offline
external usenet poster
 
Posts: 1,163
Default Variable in more than one module

Define it as Public in the declarations section (top; before any subs or
functions) of the module it is in.
--
- K Dales


"Nick M" wrote:

What is the best way to define a variable in one module and have it be held
constant in all other modules, fucntions, etc....?

Nick M.