Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Eliminate Variant Array Elements
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Eliminate Variant Array Elements
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" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Eliminate Variant Array Elements
David wrote:
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array problem: Key words-Variant Array, single-element, type mismatch error | Excel Programming | |||
Array problem: Key words-Variant Array, single-element, type mismatch error | Excel Programming | |||
ReDim Object array as parameter of Variant array | Excel Programming | |||
Variant Array | Excel Programming | |||
variant array containing cel adresses convert to actual ranges-array | Excel Programming |