Try sticking Dynamic Array Excel VBA into google......

"Piotr" wrote in message
...
Hi
How can I change the size of array in VBA ?
Is it possible to change static array or dynamic array ?
Please, help me.

THANKS !

Best regards,
Piotr