Ms-excel error '1004':"Unable to get the Paste property of the Pictures class"

Hi All,
The macro "Generate_Pictures()" generates error-1004 "Unable to get the Paste property of the Pictures class" at line "ActiveSheet.Pictures.Paste(Link:=True).Name = "Picture1" .
This error occurs on computers of a certain group company(MS-Excel 2010) and in the other companies(MS-Excel 2010/2007) that does not happen this error.
I believe that this error is related to configurations or versions excel or windows, etc. ...

Please Login or Register  to view this content.

Could someone help me?

Tks

Portella

You're trying to set the name (.name) of the paste method. If you're pasting AND renaming it needs to be in two separate lines.

Sorry. Was unable to replicate on Excel 2010 or 2007.

Can you attach your workbook?

I can't get the code to fail in my example workbook and I'm wondering if there is something in your workbook that is contributing.

Try this, which applies the Link after the paste.

Please Login or Register  to view this content.

The paste method of the pictures object acutal returns a reference to the new pasted picture so use of .Name is valid. It's does not appear to work on my xl2010 if the link argument is included.