add to two dimensional array

  • Thread starter Thread starter GUS
  • Start date Start date
G

GUS

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.
 
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(myArray),UBound(myArray,2)).Value=myArray

Alan Beban
 
Back
Top