dynamic array redim preserve: run-time error 9, Subscript out of range.

Hi!

I found quite a few posts about this problem, but none of the answers was any use to me...

I need to redimension a 2 dimensional array in a Sub. I deleted all the code that is not of interest:

Please Login or Register  to view this content.

Can somebody tell my why I receive the Run-time error '9': Subscript out of range"?.... or even better, tell me how to avoid it?

Thanks in advance!

Broesel

If you use Preserve, you can only change the last dimension of the array.

The help on Redim states.

If you use the Preserve keyword, you can resize only the last array dimension and you can't change the number of dimensions at all. For example, if your array has only one dimension, you can resize that dimension because it is the last and only dimension. However, if your array has two or more dimensions, you can change the size of only the last dimension and still preserve the contents of the array. The following example shows how you can increase the size of the last dimension of a dynamic array without erasing any existing data contained in the array.

You will need to swap in dimensions