All macros failing part way through with different error messages

M

magpie

All the macros I have in various workbooks are failing - usually part-way
through - with different error messages each time. When I check the debugger
and try to edit the text, there seems no reason why there should be a
problem. The macro has so far stopped on instructions to :
- open a workbook
- select a worksheet
- paste a column in a different place

Several times the macro has just stopped running without completing and
without showing an error message.

I cannot run a host of urgent daily reports without using the macros. Please
help!
 
M

Myrna Larson

NO way to help unless you tell us exactly what the error message is and the
text of the line of code that is highlighted in the debugger.
 
M

magpie

The error messages varied and appeared random, as different error messages
appeared although a macro would halt at the same point. Some of the macros
have worked happily for years wwithout amendment. The problem appears to have
been my Personal workbook. None of its own macros would work properly and if
it was open, macros in other workbooks wouldn't work either. Re-booting
seems to have helped somewhat. The Personal workbook may just have grown too
large. I may have to re-create it.

I solved yesterday's immediate problem by copying the most urgent macros
into another workbook and closing the Personal workbook. Today, so far, there
have been fewer problems.
 
Top