tried the code but unfortunately throws up an error: PasteSpecial method of range class failed highlighting

Destn.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=True, Transpose:=False

any ideas? thx