Thread: Help with error on PasteSpecial
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Wes_A[_2_] Wes_A[_2_] is offline
external usenet poster
  
Posts: 37
Default Help with error on PasteSpecial
Sorry forgot to enter code:
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False


"Wes_A" wrote:

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




Reply With QuoteReply With Quote