Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm trying to delete shapes in a range. I have found this code from another
post, but it won't accept "TopLeftCell" (It says method or data member not found) so I put in the range I wanted it to look in, but it deletes all the shaps. Can you help me? Dim sh as Worksheet, sh1 as Worksheet Dim v as Variant, v1 as Variant Dim rng as Range, rng1 as Range Dim shp as Shape, i as Long, j as Long set sh = Worksheets("Sheet1") set rng = sh.Range("A11, B22, C33") for each shp in sh.Shapes set rng1 = sh.range(sh.TopLeftCell, sh.BottomRightCell) if not intersect(rng,rng1) is nothing then shp.Delete end if Next |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Add and delete pictures and shapes | Excel Discussion (Misc queries) | |||
Delete shapes, not buttons | Excel Programming | |||
Delete all Shapes from selected Range | Excel Programming | |||
HOW DO I DELETE SHAPES THAT ARE IN SPREADSHEETS? | Excel Discussion (Misc queries) | |||
Delete Shapes | Excel Programming |