Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
testing if there are named shapes on a sheet
Hi,
I need to test if there are 3 named shapes (box1, box2 and box3) on the worksheet or not. If they are present, delete them and if not then do nothing. Thanks, Juuljus |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
testing if there are named shapes on a sheet
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
testing if there are named shapes on a sheet
For Each shp In ACtivesheet.Shapes
If shp.Name = "Box1" Or shp.Name = "Box2" Or shp.Name = "Box3" Then shp.Delete End If Next shp -- --- HTH Bob (change the xxxx to gmail if mailing direct) wrote in message ups.com... Hi, I need to test if there are 3 named shapes (box1, box2 and box3) on the worksheet or not. If they are present, delete them and if not then do nothing. Thanks, Juuljus |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Testing selection against named range | Excel Discussion (Misc queries) | |||
how to select ALL named shapes in range | Excel Programming | |||
Testing for Named Ranges | Excel Programming | |||
Testing for named cells (i.e., ranges) | Excel Programming | |||
Testing to see if a sheet name exists | Excel Programming |