Hi
I recorded this macro by performing the steps.

I copied a range from workbook1, switched to workbook2, activated record new macro, then edit paste special and ticked "values", ok. Stop recording.


Sub test()
'
' test Macro
' Macro recorded 2015-12-20 by GT
'

'
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End Sub

Then, I copy the same range off wb1, switched to wb2, run the macro and got this error.

Any ideas?

Thx