saxonman
07-17-2007, 06:34 AM
Hi, I have generated a bunch of charts using VBA.
Everything worked fine. However I created those charts based on data that was only temporarily available (while looping thru the macro).
When I hit F9 now all my pretty charts go blank because the data is gone. Anyway to prevent that?
So I am pretty much looking for a vba property that I dont know.
THANKS a lot!!!!
Everything worked fine. However I created those charts based on data that was only temporarily available (while looping thru the macro).
When I hit F9 now all my pretty charts go blank because the data is gone. Anyway to prevent that?
So I am pretty much looking for a vba property that I dont know.
THANKS a lot!!!!