Macro halt - Why?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Good morning,

I have a pretty large macro and when I run it, it comes to a halt, with an
error of non blank cells (it stops on a line where I am inserting a column).
I had to stop the code, then I manually tried to insert a column, and it
didn't work.

NOW, after a several minutes later, I tried to insert the column and IT
WORKS! Why is that? It makes no sense to me. Is it working behind the
scenes?

I hear a lot about screenupdating and calculation turning off. Would that
help? I do not have them in my code. If you think I need it, where should I
put them?

Thanks.

.

Relevant Pages

  • Re: Save Worksheet at .txt
    ... some of the cells contain more than 255 characters, which stops the ... macro in its tracks. ...
    (microsoft.public.excel.programming)
  • Halt A Macro If a Cell Contains a Certain Value
    ... I'm looking for a macro to be halted if the value in a cells is less than a ... with a dialog box informing the user appearing ... Cell with value is C1 and anything less than 10, should halt the existing ... Macro I have, with a Dialog box appearing showing "Halt Who goes there" ...
    (microsoft.public.excel.programming)
  • Re: A Macro to Edit Cell Content
    ... select the range of cells ... if you need a macro, turn on the macro recorder while doing the above ... and stops after it removes the last ...
    (microsoft.public.excel.programming)
  • macro for duplicate values
    ... I would like to run a macro that looks in Column A, finds the first value, ... deletes the duplicate 1120's and stops at 1140 and bring it's adjacent cells ...
    (microsoft.public.excel.worksheet.functions)
  • How do I make a macro automatically select Yes when a yes/no box appears?
    ... I run a macro that replaces cells, and it stops and asks, "do you want ... to replace the contents of the destination cells?" ...
    (microsoft.public.excel.programming)