using cells to define range gives run time error

I run a macro with the following code:

Please Login or Register  to view this content.

And it works fine, copying the cells from name1 to name2.

If I replace the code with this:

Please Login or Register  to view this content.

I get Run time error 1004: Application defined or object defined error

Why?

Many thanks!

Any unqualified range reference in a code module refers to the active sheet:

Please Login or Register  to view this content.

Since only one (at most) of those sheets can be active at a time, one of those lines will ALWAYS generate an error.

You can qualify the cells inside the two argument form of Range

Please Login or Register  to view this content.