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.

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.