Paste Values Without Selecting the destination range

I'd like to make my code just a little more succinct and in the process speed up its execution. I have a lot of copy/paste iterations. I'd like to be able to do the paste part without actually activating or selecting the destination range. Here is my code so far:

Please Login or Register  to view this content.

It's the last four lines that I'd like to condense into possibly a singe line or maybe two. Something along the lines of this would be ideal (except that this doesn't work as written):

Please Login or Register  to view this content.

Anyone have any suggestions? Thanks.

Possibly with...

Please Login or Register  to view this content.

To speed up my code I use these two commands at the front, but don't forget to turn them back on again at the end.

Please Login or Register  to view this content.

This stops the screen from flick around as the code is running and

Please Login or Register  to view this content.

which stops all the individual calculations while the code is running.