Static Variables

[Guest]

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

 

[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* ?

 

[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

 

[mg]

Sun, 8 Aug 2004 17:03:57 -0500, Chip Pearson wrote :

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

Ah yes