To paste as values use this:
This will keep copied information in Excels memory. To clear memory use this after all pasting actions in the code:
application.cutcopymode = false
Using the macro recorder is a very handy tool to figure out how to do certain things in vba. So if for example you want to know how to paste format only, record macro, do the actions, stop recording and check the code.
This is just a general tip, so don't be afraid to ask here.