Simplied VBA code to copy value of range from another worksheet

[Chrispelletier]

I am working on a macro that used columns as number (i.e. A=1, B=2) in the VBA code and I am trying to see if I can simplified my code to copy the value of a range from another worksheet to a range on a specified worksheet. Both range are identical in size.
I was able to first get it to work within the same worksheet with this code:

Please Login or Register  to view this content.

But then I thought I could just do the below code and it would work with a range in another worksheet but I got an error (run-time error 9 subscript out of range):

Please Login or Register  to view this content.

I search the web and ultimately came up with the code below that works but I was wondering if it can simplified to a one liner similar to the code above?

Please Login or Register  to view this content.

Thank you for your time!

[bakerman2]

How about this.

Please Login or Register  to view this content.

[CK76]

The reason you are getting error in your 2nd code is that you didn't qualify Cells with sheet name.
Below will work...

Please Login or Register  to view this content.

But I'd write it like...

Please Login or Register  to view this content.

For copy method you can write as...

Please Login or Register  to view this content.

Edit: FYI - Range or Cells when unqualified will use activesheet as range parent.

[Chrispelletier]

Great, thank you all for your answer, I used CK76 first proposed answer and it worked. Thank you for your time.