Forum Discussion

Gary_Schroeder's avatar
Gary_Schroeder
Copper Contributor
Jan 18, 2020

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...
Excel on Mac
Macros and VBA
PascalKTeam's avatar
PascalKTeam
Iron Contributor
Jan 19, 2020
Maybe the screenupdating setting was changed in the VBA code? Do you have this line of code in your VBA code

Application.ScreenUpdating = False?
  • Gary_Schroeder's avatar
    Gary_Schroeder
    Copper Contributor
    Jan 19, 2020

    PascalKTeam 

     

    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.

    • PascalKTeam's avatar
      PascalKTeam
      Iron Contributor
      Jan 19, 2020
      Can you post the file? Or at least the code?

Resources