Forum Discussion
CAN ANYONE HELP??? viewing results while a macro runs
A week ago...
When I would run my testing macro, I would see the result of EACH of the 100 steps in the macro in the worksheet. I have a counter in the worksheet AND a graph display the results LIVE as the macro ran. The counter would COUNT 1 to 100, and the graph would display the REAL TIME results as the macro ran.
Today...
When I run the same macro on the same worksheet, I do NOT see the live results while the macro runs. I only see the final results when it is completed. The counter only displays 100, and the graph changes only when the macro is completed with all 100 tests.
What changed? I don't know if this is a change in Excel, or VBA, or some variable that I may have changed unintentionally.
Can anyone help????
7 Replies
- Maybe the screenupdating setting was changed in the VBA code? Do you have this line of code in your VBA code
Application.ScreenUpdating = False?Thanks for the note...but No, I do not have this line in my code. I tried adding this line, but with TRUE, and no change when running.
I am pulling my hair out as nothing changed in either the worksheet or the macro. Ugh!
Any other ideas? I am open to anything at this point.
- Can you post the file? Or at least the code?
