You should be able to record a macro copy the information  (Tools-
Macro-Record). Then, look at the macro to see how it works (Tools-
Macro-Visual Basic Editor). You may get something like:

Sub Macro1()
Sheets("Sheet1").Select
Range("A1:A3").Select
Selection.Copy
Sheets("Sheet2").Select
Range("A1").Select
ActiveSheet.Paste
End Sub

To put values in an array, you can do it like this:

Sub test()
MyArray = Sheets("Sheet1").Range("a1:a3")
'This makes a 3 by 1 variant array.
Debug.Print MyArray(3, 1)
End Sub

Simpler way:
1- Type an equals sign in the destination cell.
2- Go to the source sheet and click on the source cell.
3- hit Enter. Drag this formula wherever you want.


You used to be able to do this in another workbook, but it is not a
simple any more; it involves Open.

BTW, my on-line help gives step-by-step instructins for these
operations. It is called "Linking" for the search.

I have assinged auto_open procedure this
Code to a workbook.

ThisWorkbook.IsAddin =True

It turn out to be an add-in. But I can't use the macros in it ?
When I press Alt+F8 I can not see the macros ?
Where is the problem ?
Is there a workaround to use the macros inside the workbook ?