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

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

--
Immortal under the Sun are the gods alone,
As for mortals their days must end -
What they achieve is but the wind!
Gilgamesh ,T2

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

--
Immortal under the Sun are the gods alone,
As for mortals their days must end -
What they achieve is but the wind!
Gilgamesh ,T2

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