Redim preserve throws error

[capson]

I am trying to remove all rows from the array if certain cells are empty with

Please Login or Register  to view this content.

I get the correct range if I post back the newr array to a sheet

But I in tring to redim newArr to the proper size I get Script out of range and the Redim is hightlited

Can't figure out what is wrong, newArr has the correct dim

Thanks

Please Login or Register  to view this content.

[capson]

I keep trying to upload a file but is not working

[capson]

here is the file

[MrShorty]

As explained in the help file for the ReDim statement: https://msdn.microsoft.com/VBA/Langu...edim-statement

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.

It appears that your code is trying to redim both dimensions.

If I follow your code correctly, it looks like you are only redimming the first dimension. If that is the case, then you can probably "transpose" the array so that the changing dimension is the second dimension.

[capson]

Thank you, that got me there

Please Login or Register  to view this content.