PasteSpecial method error

[msnook]

I am using the following code:

Windows("Extracts " & MyDate & " " & ampm & ".xlsx").Activate
Sheets("H4").Select
Range("A1").Select
Range_Select
Selection.Copy
Windows("IRIS Backlog.xlsm").Activate
Sheets("H4").Select
Range("U20").PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("OC").Select

This code works fine on multiple machines, but on one it creates a "Run-time error '1004' PasteSpecial method of Range class failed" error.

Not sure why this is the case. The maching in questions has Excel 2010.

Thanks in advance for any help/insight.

 

[SkipVought]

hi,

So you're saying that the SAME WORKBOOK does not run on one machine?

I'd reinstall Excel.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}