all macros failing - different workbooks 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.

Excel also seems to be running when I try to close it or switch to a
different workbook.

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

Fredrik Wahlgren

magpie said:
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.

Excel also seems to be running when I try to close it or switch to a
different workbook.

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

What error messages do you get? Do you have error handlers in your code? One
thing that you may want to check is that you only have one instance of Excel
running. Start the task manager and select the "Processes" tab. Click on
"Image name", this will sort the processes in alphabetical order. If Excel
is running, there should be only one instance of Excel.exe.

/Fredrik

/Fredrik
 
Top