The name of a shape is in a cell and I want to indirectly reference it in vba

[Oriya]

Hello amazing people of the VBA world, I'm slowly getting better at VBA and understanding it but i'm getting a bit stuck on this particular thing and unsure why it's not working.

I've been able to indirectly reference a cell with a shape name before in order to show/hide a given shape so i know the code i wrote works, however when I try to apply it to this particular bit of code it doesn't work.

The shape I want to move is called "rya1" and the cell location to move it to is located in "AH24". When I directly reference the shape name this code works perfectly:

Please Login or Register  to view this content.

I want the shape name (because it will change) in cell "AH25" and then for the VBA to pull the name from that cell and use that shape in the code - this is what I wrote but it wasn't working.

Please Login or Register  to view this content.

Anyone any ideas why please?

[Andy Pope]

Try

Please Login or Register  to view this content.

[bakerman2]

As Andy made clear already rest of your code looks like this.

Please Login or Register  to view this content.

[Oriya]

Thanks Both of you that worked perfectly! It appears I had a rogue .Range!

[bakerman2]

Thanks for feedback and rep+.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.