Eliminate Variant Array Elements

[David]

Load array with worksheet range
Dim x as variant
x = Range(MyRange) ' n x 2 range
run process on array
How to eliminate elements (n, 1) and (n, 2)
to leave an (n-1) x (2) array?
I beleive that I cannot use ReDim on this type of array?
Thanks

 

[Peter T]

Your question is difficult to follow and ambiguous. From what I do follow,
you can use ReDim Preserve but only on the last dimension. Otherwise make a
new array sized to suit and copy what you want from the original into it
(means looping both dimensions)

Of course the simplest way would be to size and populate the array with what
you want in the first place. Append the range with .Resize() or possibly
..Offset().Resize() to suit

Regards,
Peter T

 

[Alan Beban]

Load array with worksheet range
Dim x as variant
x = Range(MyRange) ' n x 2 range
run process on array
How to eliminate elements (n, 1) and (n, 2)
to leave an (n-1) x (2) array?
I beleive that I cannot use ReDim on this type of array?
Thanks

If the functions in the freely downloadable file at
http://home.pacbell.net/beban are available to your workbook

x=SubArray(x,,,2)

Alan Beban