Hello I Have the following code:

Worksheets("Data History").Copy after:=Worksheets("Adviser")

and if produces this error:

Run-time error '1004':

Copy method of Worksheet class failed

Both Sheets referenced in the code exist in the workbook. Any Ideas why this
is happening. It only started recently. The code worked before.

Regards and thanks for all help.

Francis.