Copy and past drawing objects name problem
 

I have some drawings that are seen as “group xxxx”. When I manually cop
say “Group 1” and past it in a cell I get say “Group 3245”. When I d
this with a macro and don’t specify the past format I receive
“Picture xxxx” the drawing object is transformed in a picture (I don’
want pictures because they look ugly). When I specify the past format t
be “MS Office Drawing Object” I get a drawing object but the name is th
same as of the copied drawing “Group 1” the number from the name is no
changed like it dose when you copy it manually so I end up with a lo
of drawings that all have the same name. How can I copy a drawing an
past it as a drawing object that has a new, unique name (like in doin
it manually)

Attachment filename: drawings_copy_past.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=63198
--
Message posted from http://www.ExcelForum.com