Pasting values between ranges in different workbooks: "Range" works but "Cells" doesn't

Hello! I'm pasting ranges from one workbook to another without actually activating either.
For the "range1" variable I'm using "Range()", and for the "range2" variable I'm using "Cells()".

I'd like to use Cells() for both ranges (easier to loop through numbers than through characters, AFAIK), but I can't use Cells() for the range1. Why is this?

Thanks!

Option 1: Range() for range1 and Cells() for range2 -> works!

Please Login or Register  to view this content.

Option 2: Cells() for range1 and Cells() for range2 -> Run-time error '1004': Application-defined or object-defined error

Please Login or Register  to view this content.

You can use cells for range1 but you are missing something.

In fact you are missing it from both lines of code - the range2 line probably only works because the active sheet when you run the code is 'para Claudia'.

Anyway, what you are missing is worksheet/workbook references for Cells.

Here's one way to fix it.

Please Login or Register  to view this content.

The dots in front of Cells tie them to the workbook/worksheet in the With statement.

By the way, how are you looping?