Skip to content

Instantly share code, notes, and snippets.

View sapped's full-sized avatar

Edward Sapp sapped

  • Personal
  • noitacoL
View GitHub Profile
@sapped
sapped / RemoveUnusedNumberFormats.bas
Created January 3, 2019 18:11 — forked from airstrike/RemoveUnusedNumberFormats.bas
Remove Unused Number Formats in Excel (VBA)
Sub RemoveUnusedNumberFormats()
Dim strOldFormat As String
Dim strNewFormat As String
Dim aCell As Range
Dim sht As Worksheet
Dim strFormats() As String
Dim fFormatsUsed() As Boolean
Dim i As Integer
If ActiveWorkbook.Worksheets.Count = 0 Then