The code ran fine for me. You are right that you need to start looking at
windows. Make sure you are running in a directory that you have full
permission to read and write. When you to a sheet.copy and don't use the
after or before it creattes a new workbook. If you don't have perrmission
then that could be your source of the problem

"HamishMcT" wrote:

Thanks for the advice Joel, but even if I write the routine

sub copy_sheets()
sheets.copy
end sub

I get the errors.

Any other dieas?

Thanks very much

JT




On 8 Aug, 17:24, Joel wrote:
I don't think its the sheets.copy that is failing, but something earlier in
the code that is really causing the problem. I would check to see if there is
any ON ERROR statements in the code and comment them out to help find the
problem. Run the code without the ON ERRROR statements and see if the Error
occurs earlier in the program.