View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Brian Taylor Brian Taylor is offline
external usenet poster
 
Posts: 52
Default Variables that survive an entire session

Public variables are public to the procedures or functions within that
module. If you wanted a variable that retained its value outside the
module then you would need to declare a global variable:

Global myarray(0 to 50) as string