Home |
Search |
Today's Posts |
#1
|
|||
|
|||
All macros failing part way through with 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. I cannot run a host of urgent daily reports without using the macros. Please help! |
#2
|
|||
|
|||
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. On Wed, 23 Mar 2005 01:47:01 -0800, magpie wrote: 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! |
#3
|
|||
|
|||
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. "Myrna Larson" wrote: 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. On Wed, 23 Mar 2005 01:47:01 -0800, magpie wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Modification of Part Number (Revised) | Excel Discussion (Misc queries) | |||
Enabling macros | Excel Discussion (Misc queries) | |||
Part Number/Qty Consolidations | Excel Discussion (Misc queries) | |||
Transferring toolbars and macros to other computers | Excel Discussion (Misc queries) | |||
The available macros list in XL; how to suppress filename from showing | Excel Discussion (Misc queries) |