Created
April 27, 2019 11:15
-
-
Save DataSolveProblems/efea6df54bb1014ef041704d0e45c491 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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