Skip to content

Instantly share code, notes, and snippets.

@DataSolveProblems
Created April 27, 2019 11:15
Show Gist options
  • Save DataSolveProblems/efea6df54bb1014ef041704d0e45c491 to your computer and use it in GitHub Desktop.
Save DataSolveProblems/efea6df54bb1014ef041704d0e45c491 to your computer and use it in GitHub Desktop.
Sub Delete_Strikethrough_Rows()
Dim ws As Worksheet
Dim LastRow As Long, RowNumber As Long
Application.FindFormat.Font.Strikethrough = True
Set ws = ThisWorkbook.ActiveSheet
With ws
LastRow = .Cells(Rows.Count, "C").End(xlUp).Row
For RowNumber = LastRow To 4 Step -1
If .Cells(RowNumber, "C").Font.Strikethrough = True Then
.Rows(RowNumber).Delete
End If
Next RowNumber
End With
Set ws = Nothing
End Sub
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment