Paste Range Objects

[drchris]

Hi Guys,

I'd appreciate some help with the following please.

I am creating a macro to copy specific columns from one worksheet and paste it into another. I am declaring variables for the ranges, but I dont know how to paste them into my new spreadsheet.

This is my code:

Please Login or Register  to view this content.

The last 2 lines of the code don't work. How can I change it to past the two range objects?

Thank you
Chris

[Andrew-R]

Change "Let" to "Set"?

[romperstomper]

You need to actually copy and paste them:

Please Login or Register  to view this content.

or resize the destination range and set the Value of one equal to the Value of the other if you don't want all the formatting and formulas etc.

[Andrew-R]

Oh, and get rid of the .Range property, e.g.

Please Login or Register  to view this content.

[drchris]

Thanks for the responses chaps. Not much luck tho.

I get invalid use of property if I remove the .Range!

Oh, and get rid of the .Range property, e.g.

Please Login or Register  to view this content.