Array losing value after leaving "relevant module"???

[Durlov]

Hey All,

Couldn't find a post for this after searching Google, but my Array is losing it's values for the elements after it leaves the Module. See below both AV(1,1) and AV(1,2) have values while the program is in the EOY Module.

ExcelCapture.jpg

But as soon as it exits the "EOY" module and goes to the "Main" module the values become 0.

ExcelCapture2.jpg

Can anyone tell me why this is happening? Also, it's a big program so if you need a bit of the code let me know what part and I'll provide it. Thanks!!!

[AB33]

Guess: The array is declared in the module "EOY" module and now you want to use it in a different module. Right?
If "EOY" module is ended with sub then the value of the array will be lost.

[shg]

See Help for Understanding the Lifetime of Variables and Understanding Scope and Visibility

[jaslake]

Hi Durlov

Use a Public Variable...see this link
http://books.google.com/books?id=0wC...ed=0CEEQ6AEwAg

[Durlov]

Array is declared as a Public Variable in the Main module.

[Durlov]

As Variant also - not sure if that matters

[Durlov]

Also note that AV(1,3) maintains it's value for some reason.

[Norie]

Can you post the code and/or attach a sample file?

[Durlov]

Okay my bad. First time I've written something this huge and not keeping track of the variables very well. I am using "Option Explicit", but still... Later on in the EOY module, because a variable is empty, the codes going into an if statement it's not supposed to.

So sorry to waste your times, but still thanks for looking into it.