Additionally I just went to the end with statement to skip it on that particular chart, then I continued it, and it ran the rest of the way and terminated properly.
So I guess the question is no longer is it a memory issue, because I don't think it is.
Why would 1 chart out of the 120 give...
Hi all. I have made a macro that does the exact same thing for 20 worksheets. I make 6 charts. Then I add a text box. I had the code working where it did everything I wanted without any problems.
I added an additional chart and now when I run the code the macro runs fine for 7 of the...
combo, I've thought about using that code. I was hoping to copy all the shapes at once so then I could loop through all the worksheets (22 of them) and paste them all at once. Otherwise I need to create a loop for each shape.
Fr33dan, when I do what you suggest I get the same error I got...
Thank you combo for your response.
I was wondering if the first lines of code can be made more efficient. It really slows down the macro to actively select the shapes, then copy then paste.
There are ways to copy information in cells without the select, copy,paste method, and I was hoping...
Thank you for all the solutions to questions others have posted. I've been able to get pretty far in VBA without having to ask any questions, simply by reading what you all have written here. So now I have problems with what should be pretty simple...
Problem: I can't seem to find an...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.