My Daily Microsoft
Notes from my daily work involving SharePoint, Excel and other Office applications.
Showing posts with label
shape
.
Show all posts
Showing posts with label
shape
.
Show all posts
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
Older Posts
Home
Subscribe to:
Posts (Atom)