copying an array from workbook a to workbook b

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
Can someone please tell me how I can copy an Array from workbook a to
workbook b?
Say, there is an array(0..10) named items in workbook1.sheet1 I need to
copy that to workbook2.sheet1.

Thanks,
 
workbooks("Workbook1.xls").Worksheets("Sheet1") _
.Range("A1:A10").Copy Workbooks("Workbook2.xls") _
.Worksheets("Sheet1").Range("A1")

That is my best guess of what you are asking
array(0..10) named items
Click to expand...

doesn't describe anything meaninful to me.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scattered array cells copy to scattered array cells another workbook 14
Copy Sheet to New File Without Code 5
Copy data from workbook 2 to workbook 3 mystery! 2
Cell values to an array, then array transpose to another workbook 8
STOP close button on another workbook 6
VBA code for pasting links -- modifying RDB code for summary workbook 10
Workbook Variables 2
Copy a sheet in one workbook to another workbook in VBA 2

Back
Top