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?

Improve company productivity with a Business Account.Sign Up

x
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.