Clear Picture

Hello, how do i code in vba a macro that will go to sheet 17 and delete only the shapes labled Picture 19 and Picture 22.
sandramacAsked:
Who is Participating?
 
zorvek (Kevin Jones)Connect With a Mentor ConsultantCommented:
Public Sub DeletePictures()
   
    On Error Resume Next
    With Worksheets("Sheet 17")
        .Shapes("Picture 19").Delete
        .Shapes("Picture 22").Delete
    End With

End Sub

Kevin
0
 
sandramacAuthor Commented:
Thanks
0
All Courses

From novice to tech pro — start learning today.