I have a worksheet that has 1 chart object. If I copy that worksheet within the same workbook and then attempt to execute either of the following in code I get the error in the subject line:

Sheets(SheetName).Cells.Clear
Cells.Clear

If I copy the worksheet, save the changes and then close the XLS file I can re-open it and the above lines of code do not result in an error. It is only after a sheet as been duplicated and the file not saved and closed that results in the error. If I remove the chart from the sheet then no error occurs at any point. The cells to which the chart is referencing contain numbers and not formulas.

Any ideas?

Thanks
Ed