vba to copy a picture from a hidden sheet and paste in visible sheet?

I can't get this to work! The only way I can make it work is to make the sheet visible, copy the picture, then hide it. Is there a better, more efficient way of doing this? Thanks!

Please Login or Register  to view this content.

Try something like this...

Please Login or Register  to view this content.

Originally Posted by ARowbot

Try something like this...

Please Login or Register  to view this content.

Thanks for the reply ARowbot, but I tried that code (which seemed to be missing paste?), as well as two others and it causes an error.

Please Login or Register  to view this content.

I see the problem now...The problem is that VBA doesn't seem to be able to copy a picture without first selecting it unlike a cell for example. This is a problem because you cannot select the picture on a hidden sheet. So I am unable how you can do it without unhiding then copying then hiding the sheet.

Ok, thanks ARowbot for trying!

Well, after some websearching I found the answer!

Please Login or Register  to view this content.

Well that didn't work as planned! I need it to keep the picture name as picture 4 so I can remove it, but the code I found names the picture whatever number it wants! Is there a simple way to make this work?

Thanks xladept! Will this work if there is other pictures on the worksheet? I only want this one named picture 4.

That should work then! I will give it a try, although I switched that sub to using an "IF" statement and copy/paste linked picture, which I like better, but I am wondering if it slows down the spreadsheet.