Hi Roy,
To paste as values use this:
Worksheets("Allocation").Range("K9:Y262").copy
Worksheets("WebADI").Range("C"&rows.count).end(xlup).offset(1,0).pastespecial Paste:=xlPasteValues
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.
Best regards,
Trowa
thank you very much for your response its made a huge dent in what i am trying to do. It worked in regards to pasting the information over, however i will need to paste as values in order to stop all the formulas ref'ing out, can you please help me further in pasting the same code as values.
Thank you Roy