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: