Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
double array
I have to process 4-7 sheets with similar columns. WHat i
have to do is I have to search for the column heading "GF", "Total" in all the sheets (all sheets are exactly similar). Ihave to also search for last rows in all the sheets. THis is simple as i can create array of variables. Like i can store lastrow(1)...of sheetone and likewise. But the confusing part is when i have to trap a series of values in an array in each sheet. Here i feel i need to create double arrays. Like if i am on sheet 1 then something like trapCelValue(sht1,counter1) so sht1 will be the variable which stores sheet numbers.... and counter1 will be the counter for storing hte values. like in sheet1 i will have to store values like : 13, 18, 45, 22, 90 so my array should be trapCelValue(1,1)="13" trapCelValue(1,2)="18" trapCelValue(1,3)="45" trapCelValue(1,4)="22" trapCelValue(1,5)="90" i am slightly confused as to how to declare and process... any simple example will be helpful thanks a lot |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
double array
Just declare a 2D array:
Dim trapCelValue(1 To 5, 1 To 10) As String You seem to be treating the numbers as text as you have enclosed them in quotes. Or you could remove the quotes and declare trapCelValue as a numeric data type. Substitute the actual upper bounds for 5 and 10. -- Vasant wrote in message ... I have to process 4-7 sheets with similar columns. WHat i have to do is I have to search for the column heading "GF", "Total" in all the sheets (all sheets are exactly similar). Ihave to also search for last rows in all the sheets. THis is simple as i can create array of variables. Like i can store lastrow(1)...of sheetone and likewise. But the confusing part is when i have to trap a series of values in an array in each sheet. Here i feel i need to create double arrays. Like if i am on sheet 1 then something like trapCelValue(sht1,counter1) so sht1 will be the variable which stores sheet numbers.... and counter1 will be the counter for storing hte values. like in sheet1 i will have to store values like : 13, 18, 45, 22, 90 so my array should be trapCelValue(1,1)="13" trapCelValue(1,2)="18" trapCelValue(1,3)="45" trapCelValue(1,4)="22" trapCelValue(1,5)="90" i am slightly confused as to how to declare and process... any simple example will be helpful thanks a lot |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Complex conditional summing - array COUNT works, array SUM gives#VALUE | Excel Worksheet Functions | |||
Prevent cell/array references from changing when altering/moving thecell/array | Excel Discussion (Misc queries) | |||
Is it poss to have a double array in Excel 2003? | Excel Worksheet Functions | |||
double axis, double problem (i hope only to me) | Charts and Charting in Excel | |||
meaning of : IF(Switch; Average(array A, array B); array A) | Excel Worksheet Functions |