Home |
Search |
Today's Posts |
#1
|
|||
|
|||
all macros failing - different workbooks different error messages.
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! |
#2
|
|||
|
|||
"magpie" wrote in message ... 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! 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
All macros failing part way through with different error messages | Excel Discussion (Misc queries) | |||
Enabling macros | Excel Discussion (Misc queries) | |||
Transferring toolbars and macros to other computers | Excel Discussion (Misc queries) | |||
Automatic updating worksheet data between different workbooks | Excel Worksheet Functions | |||
Workbooks...I'll try this again... | Excel Discussion (Misc queries) |