Problem Moving & copying Worksheet

[mikeymay]

I have a process which copies a template worksheet for each day of a month which seems to suddenly not like the final day of the month, although I don't think this is relevant to the problem.

I am using the following to execute the copy

Sheets("Daily").Copy After:=Worksheets("Demand")

which returns a run time error - 'Copy methos of worksgeet class failed'.

I am struggling to understand why this is happening and I also can't seem to perfomr this command manually (Edit, Move or Copy sheet, etc).


Thanks

 

[mikeymay]

After a bit of mooching around the net and test, the following has resovled the issue

http://support.microsoft.com/kb/210684