Hello,

I am trying to set some values for a range but am a bit stuck.
When using this code it works fine:
Workbooks("Book2.xlsx").Sheets("Sheet1").Range(Cells(1,1), Cells(1, 2)).Value = Workbooks("Book1.xlsx").Sheets("Sheet1").Range("A1:B1").Value
But when using this code i get a Run Time Error 1004
Workbooks("Book2.xlsx").Sheets("Sheet1").Range(Cells(1,1), Cells(1, 2)).Value = Workbooks("Book1.xlsx").Sheets("Sheet1").Range(Cells(1,1), Cells(1, 2)).Value
Can any body help me here and point out why this produces an error, i want to use the second option to set values for a variable range and prefer to use the Cells() method?

Thanks!