Jan 18 2020 11:54 AM - edited Jan 18 2020 03:43 PM
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????
Jan 19 2020 12:22 AM
Jan 19 2020 11:19 AM
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.
Jan 19 2020 11:21 AM
Jan 19 2020 11:31 AM
Jan 19 2020 12:05 PM
Jan 19 2020 12:10 PM
I will try this...but I really don't want to wait 100 seconds for the testing to complete.
Before, it would take maybe 10 seconds to complete, but I could see it working. The way it is, I don't know if it is working, if it is completed with a new test...unless I notice the new results in the worksheet.
But, let me try this an get back to you later. Thanks.
Jan 19 2020 12:15 PM