Excel VBA Tips
Search This Blog
Thursday, 26 July 2012
DELETE ALL SHAPES IN YOUR WORKSHEET
Paste below code in module and run it
Sub delete_shapes()
Dim i As Integer
For i = ActiveSheet.Shapes.Count To 1 Step -1
ActiveSheet.Shapes(i).Delete
Next
End Sub
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment