Drawing Arrows

[Bob Leathers]

Hello Folks-

I am trying to draw and arrow which is no problem using the automatic
recording macro function is Excel 97. The problem comes in when I try to
delete the same arrow using the same recording method. After all is
done, when I run the "ShowArrow" it works fine, but when I run the
"DeleteArrow" the macro fails?

There will hopefully be multiple arrows on the spreadsheet.

The VB error is "The item with the specified name wasn't found"
The code is
ActiveSheet.Shapes("Line 18").Select
Selection.Delete

Perhaps I need to identify the "Line 18" in a different way?

Any help?

Thanks Again

 

[Anders S]

Bob,

ActiveSheet.Shapes("Line 3").Delete

works fine for me (no need to "select"). "Line 3" is the *name* of the shape, it is not the *third* shape, maybe that is the problem.

HTH
Anders Silven

 

[Bob Leathers]

Thanks Anders, but that did not help got the same VB error message

 

[AlfD]

Hi!

If you select the arrow you have drawn, what name appears in the Nam
Box? Should be the name you need to kill it.

Is it actually Line 18?

Al