In message
at 17:55:16 on Fri, 14 Sep 2007, Mike
S wrote
In message
at 20:55:27 on Thu, 13 Sep 2007, Mike
wrote
Sorry I was lying. The array must have been initialised when I was
playing around with it

In my example of reading liNumShares (whose value is 102), and then
using ReDim goShares(liNumShares), this causes the memory usage to go
up. However if I manually RedDim goShares(102) this works fine.

Very strange indeed

I think I've found the solution to this now

Soln to upgrade to patch to SP2 wasn't correct. I changed my num vars
from Long's to Integer's even though UBound returns a type long - this
seems to be what does the trick, although I haven't tried it enough
times to give me confidence yet
--
Mike News