Hi,

Please could you help?

I have the following program

[VBA]
Sub MyProgram1()

dim RefWeights() as variant

'code goes in here

Sub Myprogram2()

dim RefReturns(), dim LossParam()

LossParam(x) = RefReturns(x)*RefWeights(x)

'code goes in here

end sub

[/VBA]


As you can see from the above, RefWeights array was filled in the first sub routine, is there a way i can modify my code so that the contents of the Refweights array are available to use in the second sub routine?


Thanks for your help.