Thread: Move Method
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Francis Brown Francis Brown is offline
external usenet poster
 
Posts: 57
Default Move Method

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.