2003

Forgot to turn Calculate to manual - then ran a macro.

Attempted to "Esc" and "Ctrl-Break" often but to no avail.

I am testing VBA and no real need to obtain or hold the data (copy of orig file)

Is there a way to abort the calculation in progress, to be able to save any changes in VBA Code
being tested?

TIA Eagleone

Additional, the w/s in question has 47,000 rows.

I did later than my original post, set the calculation to manual "Application.Calculation =
xlCalculationManual" in the Immediate window, (but not had saved the file - does that matter?). Then
I (just) selected on a single column and the w/s started calculating at the moment of my selection.

Why is this happening?

TIA EagleOne


wrote:

2003

Forgot to turn Calculate to manual - then ran a macro.

Attempted to "Esc" and "Ctrl-Break" often but to no avail.

I am testing VBA and no real need to obtain or hold the data (copy of orig file)

Is there a way to abort the calculation in progress, to be able to save any changes in VBA Code
being tested?

TIA Eagleone

Click on Tools | Options | Calculation tab, then ensure that Manual is
checked. You can also uncheck the Recalculate before save option, so
that you can save your changes to the macro more quickly.

Hope this helps.

Pete

On Jun 19, 1:22*pm, wrote:
Additional, the w/s in question has 47,000 rows.

I did later than my original post, set the calculation to manual "Application.Calculation =
xlCalculationManual" in the Immediate window, (but not had saved the file - does that matter?). Then
I (just) selected on a single column and the w/s started calculating at the moment of my selection.

Why is this happening?

TIA EagleOne



wrote:
2003

Forgot to turn Calculate to manual - then ran a macro.

Attempted to "Esc" and "Ctrl-Break" often but to no avail.

I am testing VBA and no real need to obtain or hold the data (copy of orig file)

Is there a way to abort the calculation in progress, to be able to save any changes in VBA Code
being tested?

TIA Eagleone- Hide quoted text -

- Show quoted text -

Thanks for your information Pete. That said, our posts may have crossed. I had set the w/s to
manual, saved the file, made sure that the Autofilter was off, then selected an entire column, then
Excel grabbed 98% of the processor time and I was stuck again.

For the life of me, I do not believe that I have seen this behavior before.


Pete_UK wrote:

Click on Tools | Options | Calculation tab, then ensure that Manual is
checked. You can also uncheck the Recalculate before save option, so
that you can save your changes to the macro more quickly.

Hope this helps.

Pete

On Jun 19, 1:22*pm, wrote:
Additional, the w/s in question has 47,000 rows.

I did later than my original post, set the calculation to manual "Application.Calculation =
xlCalculationManual" in the Immediate window, (but not had saved the file - does that matter?). Then
I (just) selected on a single column and the w/s started calculating at the moment of my selection.

Why is this happening?

TIA EagleOne



wrote:
2003

Forgot to turn Calculate to manual - then ran a macro.

Attempted to "Esc" and "Ctrl-Break" often but to no avail.

I am testing VBA and no real need to obtain or hold the data (copy of orig file)

Is there a way to abort the calculation in progress, to be able to save any changes in VBA Code
being tested?

TIA Eagleone- Hide quoted text -

- Show quoted text -

Well if you are developing and testing the macro as you go along, why
don't you set up breakpoints at appropriate positions in the macro, so
that you can run up to that point, switch to single-stepping, and
abort if necessary?

Pete

On Jun 19, 1:45*pm, wrote:
Thanks for your information Pete. *That said, our posts may have crossed. *I had set the w/s to
manual, saved the file, made sure that the Autofilter was off, then selected an entire column, then
Excel grabbed 98% of the processor time and I was stuck again.

For the life of me, I do not believe that I have seen this behavior before.



Pete_UK wrote:
Click on Tools | Options | Calculation tab, then ensure that Manual is
checked. You can also uncheck the Recalculate before save option, so
that you can save your changes to the macro more quickly.

Hope this helps.

Pete

On Jun 19, 1:22*pm, wrote:
Additional, the w/s in question has 47,000 rows.

I did later than my original post, set the calculation to manual "Application.Calculation =
xlCalculationManual" in the Immediate window, (but not had saved the file - does that matter?). Then
I (just) selected on a single column and the w/s started calculating at the moment of my selection.

Why is this happening?

TIA EagleOne

wrote:
2003

Forgot to turn Calculate to manual - then ran a macro.

Attempted to "Esc" and "Ctrl-Break" often but to no avail.

I am testing VBA and no real need to obtain or hold the data (copy of orig file)

Is there a way to abort the calculation in progress, to be able to save any changes in VBA Code
being tested?

TIA Eagleone- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

Actually, I was doing that until I hit one single line

Wks.Range("U:U,V:V,W:W,X:X,Y:Y").EntireColumn.Dele te

(I had previously formated those columns with a non-general numberformat. I had no idea that that
would come back to haunt me - see below)

This caused/causes major time issues. I have made some headway though.

I noticed that if I deleted columns 5+ columns to the right of any usedrange issues,
I had no problems. BUT, if I attempted to delete any column subjected to formating
Time issues occured.

My conclusion so far is formatting an entire Column or Columns with even a non-general
NumberFormat causes the entire column(s) to be-in-play. Apparently, this becomes when the w/s has
quite a number of rows i.e. my case 47,000.

My point, I have gone back and limited ranges to be formated i.e.:

Not: Columns("T:T")..NumberFormat = "0_);(0)"

Yes: Wks.myRange.Columns("T").NumberFormat = "0_);(0)"






Pete_UK wrote:

Well if you are developing and testing the macro as you go along, why
don't you set up breakpoints at appropriate positions in the macro, so
that you can run up to that point, switch to single-stepping, and
abort if necessary?

Pete

On Jun 19, 1:45*pm, wrote:
Thanks for your information Pete. *That said, our posts may have crossed. *I had set the w/s to
manual, saved the file, made sure that the Autofilter was off, then selected an entire column, then
Excel grabbed 98% of the processor time and I was stuck again.

For the life of me, I do not believe that I have seen this behavior before.



Pete_UK wrote:
Click on Tools | Options | Calculation tab, then ensure that Manual is
checked. You can also uncheck the Recalculate before save option, so
that you can save your changes to the macro more quickly.

Hope this helps.

Pete

On Jun 19, 1:22*pm, wrote:
Additional, the w/s in question has 47,000 rows.

I did later than my original post, set the calculation to manual "Application.Calculation =
xlCalculationManual" in the Immediate window, (but not had saved the file - does that matter?). Then
I (just) selected on a single column and the w/s started calculating at the moment of my selection.

Why is this happening?

TIA EagleOne

wrote:
2003

Forgot to turn Calculate to manual - then ran a macro.

Attempted to "Esc" and "Ctrl-Break" often but to no avail.

I am testing VBA and no real need to obtain or hold the data (copy of orig file)

Is there a way to abort the calculation in progress, to be able to save any changes in VBA Code
being tested?

TIA Eagleone- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -