I hope someone can help cos I am stuck!
I have a procedure that creates an array (variant). The variant/array's size
is dependant on various criteria it encounters at run-time so I'm using
'redim preserve' each time during a loop to make it bigger. At the end of the
code running, the array is typically (20 * 2* 76) parts big, and I'm done
with using it - the data in it's been used etc.
My problem is that; I open Excel. Run the procedure. It works perfectly. I
run the procedure again, the variable is twice as big as it was before at the
end of the procedure = somehow, it's kept the data in it after the code has
stopped.
How is that possible?? It works fine if I close Excel again & run it again,
obviously but all the books I've read say that the life of a variable only
exists whilst code is running...
Code execution is stopped by an 'Exit Sub' in front of a load of things that
error trappers Goto & then Return to the code above it. The code stops as it
should at the 'Exit Sub'.
Any help much appreciated as always.
Thanks,
Steven Douglas
--
Regards,
Tom Ogilvy
"Doug" <Do...@discussions.microsoft.com> wrote in message
news:E8A31F67-9D05-44BB...@microsoft.com...
Anyway. Cheers.
Doug