Clearing public arrays

[Guest]

I am using several 2 simentional arrays as public arrays so that I can pass
the same array through a set of code regardless of where it comes from. I
notice that if I run a proecure involving these arrays, everything is fnie
the first time around. If I then activate the same procedure again, I find
the arrays still have saved their dimensions from the first run, and when I
redim to set the first dimension, I get an error (since you can't change the
first dimension once the second is declared.

Is there anyway to clear the cache of these public arrays inbetween
procedure runs?

If I hit the stop in VBA, it clears the arrays, but obviously that's a bit
cumbersome. Thanks for any help.

 

[Bob Phillips]

Erase aryName

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

Thanks a lot Bob.
--
*********************
J Streger
MS Office Master 2000 ed.
MS Project White Belt 2003