nagovind
Member
Dear All
For example i have some values say 1 to 1000
Is it possible using ARRAY function to store the values in array using a FOR loop by VBA so value inside the array will be 1, 2 , 3 ....1000
after For loop terminates i want to recall the value in array position say 58
so array (58) i have to use...i.e without storing the value in excel sheet....
In other words Before Scope of Variable ends i will use the value
I believe scope of a variable is still alive for a whole program during running (from Sub to end Sub)
Is it possible ?
For example i have some values say 1 to 1000
Is it possible using ARRAY function to store the values in array using a FOR loop by VBA so value inside the array will be 1, 2 , 3 ....1000
after For loop terminates i want to recall the value in array position say 58
so array (58) i have to use...i.e without storing the value in excel sheet....
In other words Before Scope of Variable ends i will use the value
I believe scope of a variable is still alive for a whole program during running (from Sub to end Sub)
Is it possible ?