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

The obvious question is why? What's in a name?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Albert" wrote in message
...
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

Because depending on other conditions, I might have to use the whole array,
or parts of it. Using parts of the array yields considerable time savings.
However, sometimes I have to use the whole array, so renaming is a better
option than cloning (its a public array that I need to keep for later use).
Well, its kind of confusing, I know, but renaming seems to be the best option
timewise I've come up with so far.

"Bob Phillips" wrote:

The obvious question is why? What's in a name?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Albert" wrote in message
...
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

You've lost me, if you want part of it, how does renaming help?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Albert" wrote in message
...
Because depending on other conditions, I might have to use the whole
array,
or parts of it. Using parts of the array yields considerable time savings.
However, sometimes I have to use the whole array, so renaming is a better
option than cloning (its a public array that I need to keep for later
use).
Well, its kind of confusing, I know, but renaming seems to be the best
option
timewise I've come up with so far.

"Bob Phillips" wrote:

The obvious question is why? What's in a name?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Albert" wrote in message
...
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