| 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 |
| 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 | |||
Threaded Mode
