Sparklines not refreshing while VBA is running

[nherhilan]

Hello all,

I automated a report in Excel that uses VBA to set some parameters, conditionally format charts, and then exports to PDF. It all works fine except for one thing: sparklines. Even though all my numbers and calculations and charts show the proper values when it gets exported to PDF, the sparklines aren't updating. I've tried DoEvents, using Waits (even for a full minute), a number of variations of Application.Calculate, zooming in/out, and keep getting the same results. And yes, I've spent hours Google-ing (Googling?) and experimenting and haven't found a solution to this.

If I step through the exact same code it works fine, but when the code runs by itself the sparklines don't update until the code ends.

Any suggestions are welcome, since I'm tearing my hair out.

Best Regards,

Nick

 

[pgc01]

Hi Nick

I had the same problem when I tried.

It worked for when I duplicated the DoEvents, like where I placed the DoEvents I then added another one:

' code

DoEvents
DoEvents

'code

Please try.

 

[nherhilan]

Beautiful, that worked like a charm. Thank you, thank you, THANK YOU!