Method 'Paste' of object '_worksheet' failed

[Greg Bloom]

Run time error '-2147417848 (80010108)

I am copying a range from one spreadsheet and pasting to another. Anybody
else seen this?

Greg

 

[Ron de Bruin]

Hi Greg

Post your code in this thread

 

[Greg Bloom]

On Error GoTo TemplateErrorRetailPrice '10/18/2004
Range("d" + Trim$(Str(zTopRow))).Activate
Workbooks(OE_Data).Sheets(zWorksheet).Range("l2:l2500").Copy
'10/05/04
ActiveSheet.Paste

 

[Greg Bloom]

On Error GoTo TemplateErrorRetailPrice '10/18/2004
Range("d" + Trim$(Str(zTopRow))).Activate
Workbooks(OE_Data).Sheets(zWorksheet).Range("l2:l2500").Copy
'10/05/04
ActiveSheet.Paste

 

[Ron de Bruin]

Do you run the code from a button in excel 97 ??