Eliminate Variant Array Elements

  • Thread starter Thread starter David
  • Start date Start date
D

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
 
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
 
David said:
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
Click to expand...
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
 
Back
Top