How can I get a chart to refresh itself (the source data, I mean) with VBA? I have an Auto_Open macro that needs to refresh the graphs on a particular worksheet upon opening the file.
Any help would be much appreciated.
KingMartin
Jun 23 2006, 04:03 PM
Hello,
Application.Calculate
should do the trick...
Martin
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.