3/3/2023 0 Comments Mac gridlines excel for graphIf TypeName(Selection) “Range” Then Exit Sub I am using similar code to your previous examples: Is the lack of speed perhaps due to the chart being activated when it is created, is there a way to deactivate it and add series and formatting without using the ActiveChart command? ![]() ![]() I tried to clean this up a bit by setting unused objects to nothing but the problem is still there. ![]() Assuming that this was a memory leak issue, I decided to watch the performance monitor whilst running the script and saw that the memory usage of Excel steadily increases. I also find that it gets slower the longer it runs. This code works perfectly, however, I find it to be a bit slow for my liking. Being an engineer, I like to push things to the limit so I went bananas with producing many charts from large data sets produced from batch studies. That is, I want to know how to improve the speed of VBA scripts which are creating and using many charts with many data series. I do however, have a question that I’m struggling to find a straight answer to on the net. ![]() Thanks you so much for the informative posts, they have helped me countless times.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |