I am using the following code to delete rows that have a "0" or nothing in the Column A cell value.
Sub Test1()
With Columns(1)
.Replace What:="0", Replacement:="", LookAt:=xlWhole
.SpecialCells(4).EntireRow.Delete
End With
End Sub
How would I modify this code to look in column C for cells that have a "1"? If it does then delete the whole row.
Thanks for the help.
PS what does the .SpecialCells(4).EntireRow.Delete line of code do?
Sub Test1()
With Columns(1)
.Replace What:="0", Replacement:="", LookAt:=xlWhole
.SpecialCells(4).EntireRow.Delete
End With
End Sub
How would I modify this code to look in column C for cells that have a "1"? If it does then delete the whole row.
Thanks for the help.
PS what does the .SpecialCells(4).EntireRow.Delete line of code do?