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...
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?
- thanks for the code
The macro actually does fill each row step by step. Have you changed to a PC with better performance? This could be a reason for not seeing the single steps of the macro.
What you could do is to add this line of code between the steps, this will pause the VBA execution for 1 second
Application.Wait (Now + TimeValue("0:00:01"))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.