Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
copying an array from workbook a to workbook b
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" wrote in message ... 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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copying workbook formating to a differnent workbook | Excel Worksheet Functions | |||
copying modules from one workbook to another workbook | Excel Discussion (Misc queries) | |||
Copying Formulas from Workbook to Workbook | Excel Discussion (Misc queries) | |||
Copying A Worksheet From Each Open Workbook to an new Workbook | Excel Worksheet Functions | |||
Copying tabs from one workbook to another workbook | Excel Programming |