Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Stratuser wrote: Yes, but there is one other thing: My arrays are two-dimensional, based on a row and column structure, like a range. If I use ReDim Preserve to increase the big array to add the non-duplicate elements, I can only increase the last dimension of the array. Since I'm adding rows in effect, I guess I would need the array structure to be Array(column, row) instead of Array(row, column). Right? dunno :) What kind of values have you got in the inner array? could you consolidate them to a string using Join method - for the time of comparation, and array redimensioning, and then do a loop throughout the array to split them back? It's just a loose idea, as I'd prefere to see the example itself |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Trying to append to file using an array | Excel Programming | |||
Append data from a column to separate table array | Excel Programming | |||
Consolidate data in an 2-dimension array in VBA | Excel Programming | |||
how to know which row to append for the last row | Excel Programming | |||
Qn: How to Append??? | Excel Programming |