Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Banyez

    Run-time error '1004' - can this be related to memory issues?

    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...
  2. Banyez

    Run-time error '1004' - can this be related to memory issues?

    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...
  3. Banyez

    Copying shapes and paste to different worksheets using VBA

    Yes, Those are the local names ("Line 1", "Picture2").
  4. Banyez

    Copying shapes and paste to different worksheets using VBA

    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...
  5. Banyez

    Copying shapes and paste to different worksheets using VBA

    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...
  6. Banyez

    Copying shapes and paste to different worksheets using VBA

    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...

Part and Inventory Search

Back
Top