Public Variable gone

[Ricardo Caicedo]

Good Morning guys

I have a problem with a Public Variable. I declare a PUBLIC WaveN as Integer in a general module, so I suppose the amount should be keep it all the time during the running.

The program UpdateMaster assign to the public variable WaveN a number after go through many rows (inside of this module), but then the following program TransferInfo needs that value. I got "on" the debug mode and I can see that as soon the first sub close the value just gone.

My code is follow:</SPAN>
Sub RunProgram()</SPAN>

Call UpdateMaster
Call TransferInfo
Call RangeLookFill
Call SplitInfo
Call UpdateFinal</SPAN>
End Sub</SPAN>


Any Ideas....do I have to put the UpdateMaster(WaveN) format?

 

[shg]

Is there an End statement somewhere in the code?

 

[Ricardo Caicedo]

Good morning shg. I got and end select for error handling but i think this one is not creating the problem.

The code is large, but I can see in debug mode that before the "end sub" of this module, the vatiable keeps the value, but as soon close the module the variable get <out of context> so the value is gone.

 

[Ricardo Caicedo]

I found that it works if you declares public in a separate module and also the debug program shows the wrong information as the variable keeps the value through all the execution, but it shows as 'Out of context".

Thank you for your help