G
Guest
In My spreadsheet I have in Cells A1:A9
abc
123.00
wer
654.00
765.00
432.00
ghj
mkil
ghj
My Macro is:
Sub Delete_rows_based_on_ColA()
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
Dim cell As Range, rng As Range, i As Long
Set rng = Columns("A").SpecialCells(xlConstants, xlTextValues)
For i = rng.Count To 1 Step -1
If LCase(rng(i).Value) = "ghj" _
Then rng(i).EntireRow.Delete
Next i
Application.Calculation = xlCalculationAutomatic
Application.ScreenUpdating = True
End Sub
The above is not even getting close to my cells A7 and A9 where my criteria
is; Why Not?
TIA,,
abc
123.00
wer
654.00
765.00
432.00
ghj
mkil
ghj
My Macro is:
Sub Delete_rows_based_on_ColA()
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
Dim cell As Range, rng As Range, i As Long
Set rng = Columns("A").SpecialCells(xlConstants, xlTextValues)
For i = rng.Count To 1 Step -1
If LCase(rng(i).Value) = "ghj" _
Then rng(i).EntireRow.Delete
Next i
Application.Calculation = xlCalculationAutomatic
Application.ScreenUpdating = True
End Sub
The above is not even getting close to my cells A7 and A9 where my criteria
is; Why Not?
TIA,,