Re-Setting the dimension of an array to exclude #NA values

Hi guys,

I have an array ( n rows, 2 columns) that is filled in by values from two other arrays (dim_tag,1) and (dim_iban,1) based on a condition within a loop .
Following, my code the final dimension of my array is (dim_tag,2) however since the condition is not always met the values in the array can be #NA.
How can I size the dimensions of my array that it eliminates #NA and its dimension corresponds to the number of times the condition is fit.
I tried to play around the Redim and ReDim Preserve, by sometimes declaring a fixed dimension and Redim and sometimes no fixed and Redim. I get error 9 subscript out of Range or array already dimensioned.

Any help how can I get clean array corresponding to real values ?

Many Thx.

Najwa.

HTML Code: 

Salut !

Originally Posted by Najwa_X

Any help how can I get clean array corresponding to real values ?

If original data come from an Excel sheet so better than cleaning is creating directly
the array without any error just using the appropriate Excel basics formula way !
Easy to demonstrate with an explanation and an attachment, both accurate …

Do I understand your request properly ?
You want to omit from the final array any row with a (#N/A) error.
Using an extension to your previous post see if this satisfies your requirement.

Hi Torachan, Thank you for your reply.

I can not view the code in the spreadsheet. Do you mind sending ?

Much Appreciated !

Najwa.

Please Login or Register  to view this content.