After two hours of futile search and frustration. I am posting the question here.
Can anyone please explain the detailed difference between paste and pastespecial option in excel vba?
Or cite some resources which can help
See Question&Answers more detail:os
That's simple :
Paste will paste exactly what's in the origin range (to make it simple: values or formulas)
PasteSpecial let you define what you want to paste (value, formula, style, etc..).
With:
expression .PasteSpecial(Paste, Operation, SkipBlanks, Transpose)
The first argument Paste is of XlPasteType Enumeration type that determines what you can choose
Some further read:
MSDN Range.PasteSpecial Method
The PasteSpecial VBA Command: Get VBA to Do the Hard Work for You
