Help with error on PasteSpecial

  • Thread starter Thread starter Wes_A
  • Start date Start date
W

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 ?
 
Sorry forgot to enter code:
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
 
Did you copy anything; ....try the below


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