Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
add to two dimensional array
i want to add in a two dimencional array some values and the read them and
put then on cells. I have 60 customers with ten data eatch (name,phone,street,etc) an i want to put all these data in array. How can i do that . I am not an expert in arrays. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
add to two dimensional array
If you put the data in Cells A1:J60 on Sheet1, then the following will
load them into the array: Dim myArray myArray = Worksheets("Sheet1").Range("A1:J60") If you then change the elements of the array, you can put the changed elements back on a worksheet with Worksheets("Sheet2").Range("A1").Resize(UBound(myA rray),UBound(myArray,2)).Value=myArray Alan Beban GUS wrote: i want to add in a two dimencional array some values and the read them and put then on cells. I have 60 customers with ten data eatch (name,phone,street,etc) an i want to put all these data in array. How can i do that . I am not an expert in arrays. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup within a 2 dimensional array | Excel Worksheet Functions | |||
Three Dimensional Array Question | Excel Discussion (Misc queries) | |||
2 Dimensional Array | Excel Programming | |||
2 Dimensional Array | Excel Programming | |||
Sorting a 2-dimensional array | Excel Programming |