Static Variables

  • Thread starter Man from Utopia
  • Start date
M

Man from Utopia

I'm struggling withvariables declared with the Static keyword seemingly
reinitialising themselves. My code DOES jump from module to module, but I
need to declare several arrays which will retain whatever values I write to
them until I close the application.

I guess I'm missing something obvious?

Brian Henstock
 
M

mg

Sun, 8 Aug 2004 13:07:02 -0700, Man from Utopia wrote :
I'm struggling withvariables declared with the Static keyword seemingly
reinitialising themselves. My code DOES jump from module to module, but I
need to declare several arrays which will retain whatever values I write to
them until I close the application.

I guess I'm missing something obvious?

Did you declare all variables as *Static Public* ?
 
C

Chip Pearson

Did you declare all variables as *Static Public* ?

There is no such declaration as "Static Public". Public
variables are by definition static.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Top