Insert a picture that is on worksheet into another worksheet

[jerseyguy1996]

I have written a vba program that creates a report in excel. Most of the pages of the report are created at runtime. I have an image on a hidden worksheet that I need to place into one of the worksheets that is created at runtime. The image is an excel chart that I copied and pasted as a picture. I did this so that I could resize it easily and all of the elements of the chart would maintain their relative sizes. I have tried:

sheets("Unsmoothing Examples").shapes("Picture 3135").select
selection.copy

but I get an error message:

Run-time error '1004': Copy method of Picture class failed

I tried inserting the picture like this:

sheets("Appendix II").Pictures.Insert(sheets("Unsmoothing Examples").shapes("Picture 3135")

but I get the dreaded:

Microsoft Office Excel Has Stopped Working......Windows is checking for a solution to the problem

and then of course it closes down and restarts without ever finding a solution.

Any help would be greatly appreciated.

[romperstomper]

Try using:

sheets("Unsmoothing Examples").shapes("Picture 3135").copy

[jerseyguy1996]

Try using:

sheets("Unsmoothing Examples").shapes("Picture 3135").copy

That worked perfectly. Thank you very much!!!!

[Anand_89]

Hi,
Please let me know how to align the image mid of the cell.

[arlu1201]

Anand,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.