I think that it is possible based on the following article:

www.ftponline.com/archives/premier/ mgznarch/vbpj/1997/10oct97/mc1097.pdf


But, I still don't know exactly how because playing with pointers in VBA
is dangerous -- I can't test methods of accomplishing this because
(since I don't know what to do), I encounter fatal errors fairly often,
crashing Excel.

However, I don't see any reason why we can't just set one of the array
variables equal to the other, change the original array so that it
refers to the null pointer, Erase the original array variable, and
continue working with the new array variable as if no funny business was
going on. That way, when VBA releases the memory allocated to the
variables, the original array won't release any memory since it refers
to the null pointer, and the 2nd array will release exactly what the 1st
array would have.

This may not work, I just see no reason (at this time) that it wouldn't
work.

I guess if I really want it as fast as I do, I should just learn a
language that natively supports pointers. =\