Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Declare Non-contiguous Columns as Arrays
How can I declare multiple columns as arrays where each element of
each array is a combination of adjacent (on the same row) values from two columns? I have three columns - the first contains a facility id, the second contains a material id and the third contains a material id to be referenced by the material id in the second column. I want to compare a combination of the first and second columns' values to a combination of the first and third columns' values to root out 'loops' (references pointing both ways within each facility) and instances of the second column values referring to multiple values in the third column. There will be empties in the third column, but not the first or second. Thanks! Cliff Edwards |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Declare Non-contiguous Columns as Arrays
I'm not entirely clear what you want to do, but the following code
might get you started. It declares an array Arr with 5 rows and 3 columns and then loads the array with the values from rows 1:5 columns A, C, and E. Dim Arr(1 To 5, 1 To 3) As Variant Dim RI As Long Dim CI As Long ' load the array with values from rows ' 1 to 5, columns A, C, and E. For RI = LBound(Arr) To UBound(Arr) Arr(RI, 1) = Cells(RI, "A") Arr(RI, 2) = Cells(RI, "C") Arr(RI, 3) = Cells(RI, "E") Next RI ' list the array For RI = LBound(Arr) To UBound(Arr) Debug.Print Arr(RI, 1), Arr(RI, 2), Arr(RI, 3) Next RI Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2009 Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Fri, 20 Mar 2009 11:53:45 -0700 (PDT), ward376 wrote: How can I declare multiple columns as arrays where each element of each array is a combination of adjacent (on the same row) values from two columns? I have three columns - the first contains a facility id, the second contains a material id and the third contains a material id to be referenced by the material id in the second column. I want to compare a combination of the first and second columns' values to a combination of the first and third columns' values to root out 'loops' (references pointing both ways within each facility) and instances of the second column values referring to multiple values in the third column. There will be empties in the third column, but not the first or second. Thanks! Cliff Edwards |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Declare Non-contiguous Columns as Arrays
Thanks Chip!
Cliff Edwards |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Difficulty with Arrays in Excel's DECLARE statement | Excel Programming | |||
Building Non-Contiguous Arrays For Use With Linest | Excel Worksheet Functions | |||
Copying non-contiguous columns to contiguous columns | Excel Programming | |||
Declare Multidimensional Arrays | Excel Programming | |||
Declare Multidimensional Arrays | Excel Programming |