Redim sets the array's elements to blank. You don't want to set it to blank,
so you'll have to add the values together to generate new non-blank values.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Charles" wrote in message
ups.com...
It seems (see previous discussion) that the function "redim" is much
faster than going through a loop to reset an array to its initial
value.

I was wondering if there was a similar "smart" way to add two arrays
together, ie

doing something like

X=ZeSmartFunction(X,Y)

instead of

for i = 1 to n
X(i)=X(i)+Y(i)
next i