Application defined or Object defined error

  • Thread starter Thread starter Otto Moehrbach
  • Start date Start date
O

Otto Moehrbach

Excel 2002, WinXP
I am copying from one file to another. The name of the source file is
fixed. The name of the destination file is a variable, DestFile. DestFile
in this instance is "MyFile.xls". Both files are open. The offending code
is:

Windows("Reports.xls").Activate
Sheets("Paste").Range("A2", Range("A" & Rows.Count).End(xlUp).Offset(,
1)).Copy _
Workbooks(DestFile).Sheets("Paste").Range("A2")

I get an Application defined or Object defined error on the above code.
What am I doing wrong?
Thanks for your help. Otto
 
Sheets("Paste").Range(Sheets("Paste").Range("A2"), _
sheets("Paste").Range("A" _
& Rows.Count).End(xlUp).Offset(,1)).Copy _
Workbooks(DestFile).Sheets("Paste").Range("A2")
 
Tom
I would have gone a long way before I thought of qualifying the sheet,
but it's obvious now that you pointed it out. I changed what you had to a
With Sheet/End With construct and it's fine now. Thanks for your help.
Otto
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cycle through Variables 1
copying data into a file with a modify pw & read-only recommended 3
Object variable or with Block variable not set 9
Range(sheet2) = Range(sheet1) 11
Application-defined or object -defined error continually haunting me 8
File Copy Error 1
InputBox to name a range 2
range name define on non active(focused) sheet 10

Back
Top