What is the syntax to special paste something?

Range(“<your range>”).Copy
Range(“<cell of paste location>”).PasteSpecial Paste:=<xlPasteValues, xlPasteFormats, or xlPasteFormulas>
‘examples
Worksheets (“Sheet2”).Range(“A2:B2”).Copy
Range(“C3:D3”).PasteSpecial Paste:=xlPasteValues ‘copies values of range A2:B2 from another worksheet

 

Advertisements