| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying range to other workbook
Why doesn't the following code work (subscript out of range):
Workbooks("Book3").Sheets("Sheet1").Range("Copied" ).Value = Workbooks("Book3").Sheets("Sheet1").Range("Origina l").Value The defined ranges are only 5 celles (a1:a5) Actually I want to transfer a large range (with only numbers) from one workbook to the other. Thanks for replying, Jan Bart |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copying range to other workbook
Excelerate,
Sure you have a Workbook called "Book3" open with a Sheet called "Sheet1" ? NickHK "Excelerate-nl" wrote in message ... Why doesn't the following code work (subscript out of range): Workbooks("Book3").Sheets("Sheet1").Range("Copied" ).Value = Workbooks("Book3").Sheets("Sheet1").Range("Origina l").Value The defined ranges are only 5 celles (a1:a5) Actually I want to transfer a large range (with only numbers) from one workbook to the other. Thanks for replying, Jan Bart |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copying range to other workbook
Yes I am sure
"NickHK" wrote: Excelerate, Sure you have a Workbook called "Book3" open with a Sheet called "Sheet1" ? NickHK "Excelerate-nl" wrote in message ... Why doesn't the following code work (subscript out of range): Workbooks("Book3").Sheets("Sheet1").Range("Copied" ).Value = Workbooks("Book3").Sheets("Sheet1").Range("Origina l").Value The defined ranges are only 5 celles (a1:a5) Actually I want to transfer a large range (with only numbers) from one workbook to the other. Thanks for replying, Jan Bart |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copying range to other workbook
Excelerate,
Well I cannot get a "Subscript out of range" otherwise with that line of code. Some other is causing the error ? NickHK "Excelerate-nl" wrote in message ... Yes I am sure "NickHK" wrote: Excelerate, Sure you have a Workbook called "Book3" open with a Sheet called "Sheet1" ? NickHK "Excelerate-nl" wrote in message ... Why doesn't the following code work (subscript out of range): Workbooks("Book3").Sheets("Sheet1").Range("Copied" ).Value = Workbooks("Book3").Sheets("Sheet1").Range("Origina l").Value The defined ranges are only 5 celles (a1:a5) Actually I want to transfer a large range (with only numbers) from one workbook to the other. Thanks for replying, Jan Bart |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copying workbook formating to a differnent workbook | Excel Worksheet Functions | |||
| Copying A Worksheet From Each Open Workbook to an new Workbook | Excel Worksheet Functions | |||
| Problem copying a range to a different workbook | Excel Programming | |||
| Searching a range and copying values into a new range.... **Please help** :( | Excel Programming | |||
| Copying a Filtered Range from a Sheet in another Workbook | Excel Programming | |||
Hybrid Mode
