corebook.Worksheets(SName).Move before:=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.