How do you remove/delete elements (errors) from an array?

How do you remove/delete elements from an array? Assume I have this array of paired numbers:

myArray(0) = (0.375, 0.687)
myArray(1) = (1.838, 0.159)
myArray(2) = (1.736, 0.176)
myArray(3) = (0.963, 0.382)
myArray(4) = (0.324, 0.723)
myArray(5) = (0.069, #N/A)
myArray(6) = (0.674, 0.51)
myArray(7) = (0.979, 0.376)
myArray(8) = (0.069, #N/A)
myArray(9) = (0.667, 0.513)
myArray(10) = (0.766, 0.465)...

I need to create an array without errors because I'll eventually need to take the correlation of the log of the numbers.

Hi
What about

Please Login or Register  to view this content.

Originally Posted by lRobert

How do you remove/delete elements from an array? Assume I have this array of paired numbers:

myArray(0) = (0.375, 0.687)
myArray(1) = (1.838, 0.159)
...

Is myArray really a one-dimensional array? If so, I presume the paired numbers you show are enclosed in quote marks within your program, correct? If so, mohadin's solution in Message #2 should work for you... if not, you need to show us your actual declaration for MyArray and how you assigned your paired numbers to them.

Sorry, it's not really one dimensional. It's more accurately:

myArray(0,0) = 0.375
myArray(0,1) = 0.687...

Originally Posted by lRobert

Sorry, it's not really one dimensional. It's more accurately:

myArray(0,0) = 0.375
myArray(0,1) = 0.687...

One more question... is your array really zero-based? It looks like you got your values from a worksheet (because of the #N/A error). If so, I would assume you created MyArray by assigning the range of cells to the MyArray variable like this (with an assumed data range of A1:B10)...

MyArray = Range("A1:B10").Value

If you did it that way, your array would be one-based, not zero-based. So, can you tell us exactly how you loaded the MyArray with its values?

Hi

Please Login or Register  to view this content.

I solved my problem by reading the data into an array in matched pairs and created two arrays: (1) without errors and (2) where at least one element is non-numerical.

I had to reorient the data to use the ReDim Preserve to chop off the null values array # 1.

Please Login or Register  to view this content.