Copy / Paste Values to different worksheet using Copy Destination

[TheRobsterUK]

This is the code I'm trying to use:

Please Login or Register  to view this content.

It works without the PasteSpecial on the end but it copies the formulas from CC23:EB23 on worksheet wsDevTab to B5:BA5 on worksheet wsMonthlyResults. I just want it to copy values from one worksheet to the other.

With the PasteSpecial argument I get the error "Unable to get the PasteSpecial property of the Range class".

Anyone got any ideas? It's probably just a case of a full-stop in the wrong place or something...

[AliGW]

Administrative Note:

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

[rorya]

You can't do a one line copy/paste values. You'd need either:

Please Login or Register  to view this content.

or simply assign the values:

Please Login or Register  to view this content.

[TheRobsterUK]

Great thanks Rorya. I used the second example as it seems the more efficient of the two. :-)