Pages
Home
Contact Me
Saturday, November 16, 2013
Check if there are charts on a given worksheet and if yes, delete them(VBA-Excel)
'This code checks if there are any charts on a specific sheet and, if yes, deletes them:
Sub know_if_there_are_charts()
Dim ws As Worksheet
If ws.ChartObjects.Count <> 0 Then
ws.ChartObjects.Delete
End If
End Sub
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment