Hi Francis,

Try:

Workbooks("Corebook.xls").Sheets(Sname).Move _
befo=Workbooks("NewBook.xls").Sheets("Sheet1")

---
Regards,
Norman


"Francis Brown" wrote in message
...
corebook.Worksheets(SName).Move befo=newbook.Worksheets("Sheet1")

Can you explain why the above method fails with this error.

Run time error 1004

Move method of Worksheet class failed.

I am sure corebook and newbook are defined properly.
--
Regards and Thanks for any assistance.

Francis Brown.