Yes, it can only be used in the situation as described.
Speed difference will obviously depend on the size of the array and/or the
loop count if it is run in a loop.
There will be situations though where it is useful and I use it.

RBS


"Alan Beban" wrote in message
...
RB Smissaert wrote:
Yes, simpler, but a lot slower as your Redim Preserve, as I understand
it,
makes a full copy of the array. The posted code doesn't.

RBS


And aside from not having a general SetLBound procedure and not being
available for String() arrays, the difference in speed from the general
code I posted is on the order of hundredths of a millisecond. Is that
right?

Alan Beban