VBA Code for Copy Range

I keep forgetting how to do this. I usually use the newbie way of copying and pasting, but I know there's a more succinct way to do this.

Newbie way:

Please Login or Register  to view this content.

I'm looking for something along these lines, but I'm getting the code wrong:

Please Login or Register  to view this content.

Try:

Please Login or Register  to view this content.

Ahhh. Works like a charm. Thanks alot.

My pleasure.