Dear Users,
1. I have a dynamic list of organisations.
Through VBA I insert a rectangle as shapes.
Simultaneously I assigned the created shape a macro through
2. Later this macro should plot data for different organisations.
I defined "Macro" as a function which has
Strange enough it works for some shapes but for many I get an error. Runtime error '2147024809 (80070057)'. Element with the given name not found.
I am using Office 2010.
For any solutions/suggestions I would be greatly thankful.
Best Regards
Talha
1. I have a dynamic list of organisations.
Through VBA I insert a rectangle as shapes.
Code:
Set s = Worksheets("Tabelle1").Shapes.Addshape(62, 70, 120 150, 30)
Simultaneously I assigned the created shape a macro through
Code:
s.OnAction ="Macro"
2. Later this macro should plot data for different organisations.
I defined "Macro" as a function which has
Code:
Set shapeObject = Worksheets("Tabelle2").Shapes(Application.Caller)
Strange enough it works for some shapes but for many I get an error. Runtime error '2147024809 (80070057)'. Element with the given name not found.
I am using Office 2010.
For any solutions/suggestions I would be greatly thankful.
Best Regards
Talha