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

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

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

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