Thread: copying an array from workbook a to workbook b

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

doesn't describe anything meaninful to me.

--
Regards,
Tom Ogilvy



"Jeff" <Jeff@discussions.microsoft.com> wrote in message
news:B3A88E5E-A9BF-4723-87ED-156AD28EED73@microsoft.com...
> 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,
>