deleting arrowhead lines in vba code

[smiley0q0]

ok, i don't know if this is going to make sense, but here goes anyway...

i have an excel worksheet that has a macro that draws several lines and formates them so they look like arrowheads...
now my question is... this is going to be a daily report, so i need to delete those arrows, so when macro draws new ones, there will only be one. Is there any way i can search a sheet for any line that is formated as an arrowhead style and delete them? i do have other lines in the sheet that i don't want deleted, but they are just regular flat lines.

any suggestions?

Thanks,
Smiley

 

[ETID]

You might have to track/record the drawing object names in the sub that creates the arrow lines so that you can call those names and run a sub to delete them by name.

such as....


ActiveSheet.Shapes("Line 1&quot.Select
Selection.Delete

substituting a variable for "Line 1" and looping until all recorded names have been processed....

Sorry, (I am bad at teaching) so if you need an example let me know.

 

[smiley0q0]

that sound like it will work

 

[smiley0q0]

i think an example would be easier to follow

what is your email address? or you can just send me an email, i'm at jtaylor1074@yahoo.com

 

[ETID]

I replied to your email...our server can be slow at times, bug checkers and all that stuff slowing it down.

 

[smiley0q0]

yea i tried to send you an attachment with yahoo and hotmail, neither will let me. i guess our firewalls really do work!!

i think i see what you were saying about referenceing the lines with a variable name. the macro makes about 20 different lines, would i have to have 20 different variables?

 

[ETID]

Yeah...that's why I wanted to see what the end result was, so I could possibly re-write the process in a loop

 

[smiley0q0]

what is your email address again? i deleted it out of my yahoo one yesterday, and i think i can send attachments now.

 

[ETID]

I didn't forget you...been busy with a medical matter