I am having a hard time figuring out how to make this work so hopefully someone can assist me.
1) When I try the following code in my macro it works fine:
ActiveSheet.Shapes(1).Select
Selection.Delete
But when I substitue a name like this:
ActiveSheet.Shapes("Shape_Name").Select
Selection.Delete
I get "The item with the specified name doesn't exist" error message.
2) When I go to the name manager it shows that "Shape_Name" has the Value of "Freeform 1362" and Refers To "=Freeform 1362". When I click on the object it shows as "Freeform 1362" in the name window.
What am I missing? I am writing this as a VBA Module and want to refer to all shapes by the name I give them.
TIA
1) When I try the following code in my macro it works fine:
ActiveSheet.Shapes(1).Select
Selection.Delete
But when I substitue a name like this:
ActiveSheet.Shapes("Shape_Name").Select
Selection.Delete
I get "The item with the specified name doesn't exist" error message.
2) When I go to the name manager it shows that "Shape_Name" has the Value of "Freeform 1362" and Refers To "=Freeform 1362". When I click on the object it shows as "Freeform 1362" in the name window.
What am I missing? I am writing this as a VBA Module and want to refer to all shapes by the name I give them.
TIA