Hi,
Use the Shapes collection object and count that then test for a count >0
e.g.
![]()
For Each sh In Worksheets(Array("Deployment", "Sickness (Confidential)")) If sh.Shapes.Count > 0 Then sh.Shapes.SelectAll Selection.Delete End If Next sh
Hi,
Use the Shapes collection object and count that then test for a count >0
e.g.
![]()
For Each sh In Worksheets(Array("Deployment", "Sickness (Confidential)")) If sh.Shapes.Count > 0 Then sh.Shapes.SelectAll Selection.Delete End If Next sh
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks