Help with error on PasteSpecial

[Wes_A]

Excel 2007.
Bog standard code, below produces "Real Time Error '1004'
PasteSpecial method of Range class failed."
Any ideas on what could cause this ?

 

[Wes_A]

Sorry forgot to enter code:
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False

 

[Jacob Skaria]

Did you copy anything; ....try the below


Range("A1:A10").Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
Application.CutCopyMode = False