Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
Interrupting long calculations in Excel? Hi all, I am having a verylong calculation in Excel using VBA. Of course I know I can hit ESC orCTRL+BREAK to interrupt the VBA program. But I found due to too long runningprocess, the Excel window stop to
Interrupting long calculations in Excel?
Hi all, I am having a very long calculation in Excel using VBA. Of course I know I can hit ESC or CTRL+BREAK to interrupt the VBA program. But I found due to too long running process, the Excel window stop to respond for very long time, besically it's like "not responding" situation with "not responding" on the windows title bar... It doesn't seem to accept any more key strokes, not to say ESC or CTRL +BREAK. What can I do to rein/stop my program? Thanks |
#2
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
Interrupting long calculations in Excel? Hi all, I am having a v
Try this to speed up execution
Application.ScreenUpdating = FALSE Application.Calculation = xlCalculationManual At the begining of the code and Application.ScreenUpdating = True Application.Calculation =XlCalculationAutomatic At the end of the code -- HTH, Barb Reinhardt "LunaMoon" wrote: Interrupting long calculations in Excel? Hi all, I am having a very long calculation in Excel using VBA. Of course I know I can hit ESC or CTRL+BREAK to interrupt the VBA program. But I found due to too long running process, the Excel window stop to respond for very long time, besically it's like "not responding" situation with "not responding" on the windows title bar... It doesn't seem to accept any more key strokes, not to say ESC or CTRL +BREAK. What can I do to rein/stop my program? Thanks |
#3
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
Interrupting long calculations in Excel? Hi all, I am having a v
On Jul 30, 7:30*pm, Barb Reinhardt
wrote: Try this to speed up execution Application.ScreenUpdating = FALSE Application.Calculation = xlCalculationManual At the begining of the code and Application.ScreenUpdating = True Application.Calculation =XlCalculationAutomatic At the end of the code -- HTH, Barb Reinhardt "LunaMoon" wrote: Interrupting long calculations in Excel? Hi all, I am having a very long calculation in Excel using VBA. Of course I know I can hit ESC or CTRL+BREAK to interrupt the VBA program. But I found due to too long running process, the Excel window stop to respond for very long time, besically it's like "not responding" situation with "not responding" on the windows title bar... It doesn't seem to accept any more key strokes, not to say ESC or CTRL +BREAK. What can I do to rein/stop my program? Thanks Thanks. The purpose of this is to allow me to interrupt, or speed up the code? |
#4
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
Interrupting long calculations in Excel? Hi all, I am having a
As stated in the original reply, it should help speed up execution.
-- HTH, Barb Reinhardt "LunaMoon" wrote: On Jul 30, 7:30 pm, Barb Reinhardt wrote: Try this to speed up execution Application.ScreenUpdating = FALSE Application.Calculation = xlCalculationManual At the begining of the code and Application.ScreenUpdating = True Application.Calculation =XlCalculationAutomatic At the end of the code -- HTH, Barb Reinhardt "LunaMoon" wrote: Interrupting long calculations in Excel? Hi all, I am having a very long calculation in Excel using VBA. Of course I know I can hit ESC or CTRL+BREAK to interrupt the VBA program. But I found due to too long running process, the Excel window stop to respond for very long time, besically it's like "not responding" situation with "not responding" on the windows title bar... It doesn't seem to accept any more key strokes, not to say ESC or CTRL +BREAK. What can I do to rein/stop my program? Thanks Thanks. The purpose of this is to allow me to interrupt, or speed up the code? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel takes long time to show a "custom view" | Excel Discussion (Misc queries) | |||
Interrupting long calculations in Excel? Hi all, I am having a verylong calculation in Excel using VBA. Of course I know I can hit ESC orCTRL+BREAK to interrupt the VBA program. But I found due to too long runningprocess, the Excel window stop to | Excel Discussion (Misc queries) | |||
Can't bold or format because program goes into "not responding" | Excel Discussion (Misc queries) | |||
Excel 2003 not responding to "X" to close program | Excel Discussion (Misc queries) | |||
program says "not responding" | Excel Discussion (Misc queries) |