Alistair
Your workbook or an add-in has some event code in it. This will either be
in a sheet class module or a workbook one. (I suspect the latter).
If you press Alt+F11, you will see an entry(ies) for 'ThisWorkbook'. Right
click on these and select view code. If there is code in here that is your
problem. It is another question as to whether it should be deleted or
repaired, depending on what it does and who put it there.
If you see no code then check Tools>Add-ins and uncheck one at a time and
see if the issue goes away.
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
Alastair Smith said:
When loading a sheet I am getting a message "ERROR 1004 (micosoft excel)
Copy Method of range class failed.
