Equating ranges

This might be a really simple problem, but I am new to VBA and it has been bothering me for a while.

I want to equate a worksheet's range with another worksheet's range. My code is as follows:

Please Login or Register  to view this content.

The code executes until the last line (Executes perfectly when I remove the line). When I include
Range(Cells(2, 2), Cells(z, 2)) = Sheets("DATA_CLFLINE").Range(Cells(2, 9), Cells(z, 9))
I get an error: "Application defined or object defined error"

Try:

Please Login or Register  to view this content.

I tried that. Unfortunately, I get the same error:

Run-time error '1004':
Application-defined or object-defined error.

I separated out the code and tried the following to test it:

Please Login or Register  to view this content.

The first part works, but there is something wrong with the second part.

Try:

Please Login or Register  to view this content.

Worked like a charm. Thanks a lot. Lastly, could you tell me why this happened? Is it because I am running the x64 version, which does not recognize some of the codes?

Not sure actually, I noticed it a few times myself when I try and use a range(cells(a,b),cells(x,y)) construct to define a range. I think maybe it only works on the activesheet but I'm not 100% sure on that.

Thanks a lot!