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