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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

LunaMoon - 30 Jul 2008 22:05 GMT

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

Reply to this Message

Barb Reinhardt - 31 Jul 2008 00:30 GMT

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

Signature

HTH,
Barb Reinhardt

> Interrupting long calculations in Excel?
>
[quoted text clipped - 17 lines]
>
> Thanks

Reply to this Message

LunaMoon - 31 Jul 2008 14:12 GMT

On Jul 30, 7:30 pm, Barb Reinhardt
<BarbReinha...@discussions.microsoft.com> wrote:

> Try this to speed up execution
>
[quoted text clipped - 32 lines]
>
> > Thanks

Thanks. The purpose of this is to allow me to interrupt, or speed up
the code?

Reply to this Message

Barb Reinhardt - 31 Jul 2008 16:47 GMT

As stated in the original reply, it should help speed up execution.

Signature

HTH,
Barb Reinhardt

> On Jul 30, 7:30 pm, Barb Reinhardt
> <BarbReinha...@discussions.microsoft.com> wrote:
[quoted text clipped - 37 lines]
> Thanks. The purpose of this is to allow me to interrupt, or speed up
> the code?

Reply to this Message