dynamic array causes an error.

[Solidstan]

I have a macro of which does what I need, however I don't always know what size array could be needed.
I am trying to change my array to dynamic but this causes an error.

My best knowlage to do this is to change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

BUT DOING THIS FAILS... Why?
My Code

Please Login or Register  to view this content.

Help would be really appreciated.
Thanks.

[stnkynts]

You need to redim and preserve the existing array when you add to it.

[Solidstan]

Ok thanks, I have seen redim and preserve on google, but where ever I put it this line still fails.

Please Login or Register  to view this content.

Any help where and how I would put redim preserve?
Thanks.

[stnkynts]

This should help you.

Please Login or Register  to view this content.

[Solidstan]

ahah, looks a lot cleaner than my code..
Thanks, I'll give this ago tommorrow.