Thread: Rename an Array
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Albert Albert is offline
external usenet poster
 
Posts: 203
Default Rename an Array

Hello!
I want to rename an existing array.
The trivial answer would be

dim RenamedArray() as variant
RenamedArray = OldArray

HOWEVER.....
Since the OldArray is REALLY big (300000 x 20), this operation takes several
seconds and sucks up A LOT of RAM while the procedure is executing.
Is there a way to simply rename the OldArray and not have the new array hog
up all the RAM?
Best regards and thank you in advance,
Albert C