I started Excel, Personal.xls
Created 2 Sheets, Sheet1 and Sheet2,
Created a macro, and out this in the macro
Sheets(Array("Sheet1", "Sheet2")).Select
Sheets("Sheet1").Activate
Sheets(Array("Sheet1", "Sheet2")).Copy

I ran it and got the same error
run-time error '1004' Copy method of Sheets class failed

I then put a break point on the top line of the Macro and when it hi
the break point I manually selected the 2 Worksheets and placed th
following code in my immediate box and got the same error.

Sheets(Array("Sheet1", "Sheet2")).Copy


Thanks:confused

--
Message posted from http://www.ExcelForum.com