Skip to content

Instantly share code, notes, and snippets.

@airstrike
Created July 3, 2014 17:59
Show Gist options
  • Save airstrike/4145d60fc29ee7726b41 to your computer and use it in GitHub Desktop.
Save airstrike/4145d60fc29ee7726b41 to your computer and use it in GitHub Desktop.
Excel: Delete every custom cell style
Private Sub StyleKill()
Dim styT As Style
Dim intRet As Integer
For Each styT In ActiveWorkbook.Styles
On Error Resume Next
If Not styT.BuiltIn Then styT.Delete
On Error GoTo 0
Next styT
End Sub
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment