ferrugo
09-23-2009, 05:48 AM
:) Hi everybody
(sorry about my poor english):dunno
recently i did a macro that copy a 2 dimension excel matrix
example: myarray(500,500)
and i use this information in others macros, but the problem is that,
this code take some time to do the copy, and every time i need a value of this matrix, "mayarray(500,500)", i need wait the macro copy all the excel matrix again, so i want a variable, better than a static variable, that in the end of the macro this variable store his value.
In other words, a kind of variable that non erase after a end of the macro. Static variables are erased when the code is over (if im right:doh:) .
So every time i need a information of this matrix, i dont need wait copy the matrix again.
Thanks Everybody:)
(sorry about my poor english):dunno
recently i did a macro that copy a 2 dimension excel matrix
example: myarray(500,500)
and i use this information in others macros, but the problem is that,
this code take some time to do the copy, and every time i need a value of this matrix, "mayarray(500,500)", i need wait the macro copy all the excel matrix again, so i want a variable, better than a static variable, that in the end of the macro this variable store his value.
In other words, a kind of variable that non erase after a end of the macro. Static variables are erased when the code is over (if im right:doh:) .
So every time i need a information of this matrix, i dont need wait copy the matrix again.
Thanks Everybody:)