Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
VBA just dies - EXCEL 97
On Oct 4, 4:04*pm, dranon wrote:
Anybody? I'm definitely not an expert, but I might qualify as "anybody"! Have you checked to see if the code always fails at one certain command, or within one specific routine? Have you allowed Excel and your computer enough time to process everything that's happening? Do you have another process that's jumping in and hogging memory? Have you tried things like clearing the Undo list and maybe throwing in the screen updating, since that seems to help? Maybe a few Do Events or Sleep to let the computer catch up to Excel? I'm also adding the Excel.Programming group to this - you'd probably get better answers there. Ed |
#2
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
VBA just dies - EXCEL 97
Prob'ly ought to add the rest of the original post to this:
http://groups.google.com/group/micro...f5592c181d1e1# On Oct 6, 9:40*am, Ed from AZ wrote: On Oct 4, 4:04*pm, dranon wrote: Anybody? I'm definitely not an expert, but I might qualify as "anybody"! Have you checked to see if the code always fails at one certain command, or within one specific routine? Have you allowed Excel and your computer enough time to process everything that's happening? Do you have another process that's jumping in and hogging memory? Have you tried things like clearing the Undo list and maybe throwing in the screen updating, since that seems to help? Maybe a few Do Events or Sleep to let the computer catch up to Excel? I'm also adding the Excel.Programming group to this - you'd probably get better answers there. Ed |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
OLE link between word and excel dies | New Users to Excel | |||
Application dies when you use mouse wheel in listbox | Excel Programming | |||
Macro dies in the middle of execution | Excel Programming |