Hi try this
![]()
Sub Delete() Dim Pic As Shape For Each Pic In ActiveSheet.Shapes If Pic.TopLeftCell.Row < 5 Then Pic.Delete End If Next Pic End Sub
Hi try this
![]()
Sub Delete() Dim Pic As Shape For Each Pic In ActiveSheet.Shapes If Pic.TopLeftCell.Row < 5 Then Pic.Delete End If Next Pic End Sub
Regards
tom1977
If You are satisfied with my solution click the small star icon on the left to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks