PDA

View Full Version : [SOLVED:] Need to check if a picture exist or not then delete



Daxton A.
05-17-2017, 08:46 AM
For i = 1 To 1000
If ActiveSheet.Shapes.Range(Array("Picture " & i)).Select = True Then
Selection.Delete
Else

End If
Next i

End Sub

mdmackillop
05-17-2017, 09:42 AM
I use

Sub DelPics()
Dim shp As Shape
For Each shp In ActiveSheet.Shapes
If Left(shp.Name, 3) = "Pic" Then shp.Delete
Next shp
End Sub

Daxton A.
05-17-2017, 10:02 AM
Works like a charm, Thanks!