Reference to a copied shape

[kaktus018]

Hi,
I'm new to the forum and I've got a question. I want to copy an existing grouped shape and assign an object reference to this new shape.
Simply copying works fine with this code:

Please Login or Register  to view this content.

This copies Group1 to D5.

However, I need a reference to this new object - so something like this:

Please Login or Register  to view this content.

... which isn't working. So how can I do this?

Thank you

[davesexcel]

Attaching a sample workbook enables others to work on your problem:

To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

To add a file to a new post

To add a file to an existing post.

[kaktus018]

Ok, I don't think it's very helpful with this particular issue but here is the file: test.xlsm

[davesexcel]

Will this work for you?

Please Login or Register  to view this content.

[kaktus018]

Yes, thank you very much, I can work with that. I now work with the following:

Please Login or Register  to view this content.

[LJMetzger]

Hi kaktus018 and welcome to ExcelForum,

You will usually get a much better and quicker response if you post a sample workbook. Your sample workbook was most helpful.

When cloning shapes I like to associate the name of the cloned shape with the cell location .e.g. "GroupH5".

Try the following which worked with your sample workbook:

Please Login or Register  to view this content.

If you need to delete the cloned shapes, and keep the MASTER shape, try this:

Please Login or Register  to view this content.

Lewis

[kaktus018]

Thanks for the response Lewis. Quite some code you wrote there .
What I needed was the copied object itself, which is generated in the constructor of a class. This object is then stored as a class variable. This is why I needed a reference to the copied shape. The positioning is then done with a mehod of this class.
I hoped there is a direct way of setting a reference to the copied shape, but the workaround via its name is fine for me (I needed to name it anyway). I mark this as solved.
Thanks for the responses.