My Daily Microsoft
Notes from my daily work involving SharePoint, Excel and other Office applications.
Monday, May 28, 2012
VBA: Remove All Shapes From Sheet
To remove all shapes from a sheet, use the below snippet:
Sub RemoveShapes()
Dim s As Shape
For Each s In ActiveSheet.Shapes
s.Delete
Next s
End Sub
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment