| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check for a shape - then change or delete it if it exists
I have a spreadsheet which contains lines that have been drawn using vba.
During the drawing the process they are named like this myLine.Name = "Arrow" & CStr(PasteRow). The variables "myline" (shape object) and "pasterow" (long number)have been declared and defined. When content on the spreadsheet changes the arrows' positions and lengths can be affected, or they may be deleted if no longer needed. I need to search to see if an arrow exists, change it and or delete it. What do you suggest (using Excel 2003 SP2)? -- Thanks! Mona-ABE |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Check if a File Exists | Excel Programming | |||
| verify a shape exists in the sheet | Excel Programming | |||
| Check if filename exists. | Excel Programming | |||
| How to check if the directory exists? | Excel Programming | |||
| Check whether a worksheet exists already | Excel Programming | |||
Threaded Mode
