Redim 2 dimensional array

Hi,

See attached file.

I am having a problem with using REDIM on a two dimentional array.

Please Login or Register  to view this content.

Since I only have 3 values on column E, I should get only 3 records on my array.

What do I need to change to make it work?

Regards,
Elio Fernandes

Don't forget Excel Help:

If you use the Preserve keyword, you can resize only the last array dimension

You could turn everything round:

Please Login or Register  to view this content.

or have two arrays.

edit: below posted at time of above edit with code hence duplication

As above you must reverse the dimensions - and blanks are interpreted as numeric type, so modifying your code (assuming this hypothetical):

Please Login or Register  to view this content.

So your array will end up as (0 To 1, 0 To 2) rather than (0 To 2, 0 To 1)

edit:
Preserve can be expensive so it might be better to oversize the Array (ie to Match iteration - 0 To 4, 0 To 1) and ReDim once at the end based on cnt to remove surplus.