A question about global/public variables

[Photomofo]

Can you make an array a global variable? Let's say I have an array of Dates that run from 2000 to 2050 and I fill this array at the beginning of my program. Will all the subs and functions have access to this Dates array? I've tried this out over and over again but I can't seem to get it to work so I have to refill the Dates array in each sub and/or function that needs this info. Am I doing things wrong or is there a limitation in VBA that makes it so arrays can't be global/public?

 

[RoryA]

Arrays can be public. Where did you declare the array variable?

 

[Photomofo]

Outside of the sub next to my Option Explicit statement.

I'll give it another try.

 

[RoryA]

In a normal module, or a class/worksheet/thisworkbook module?

 

[Photomofo]

It's in a normal module but it looks like I solved the problem. I was filling the arrays on startup and assuming they'd stay full. I think I need to fill the arrays each time I run the simulation. This is a lot better than filling these various data arrays 8 times per simulation. Thanks for your help.