I have found examples of how to delete a row based on text in a row, but I'm looking for VBA code that will identify rows with a integer that is >5 and then delete the entire row. Suggestions would be greatly appreciated.
Dim LR As Long
Dim r As Long
LR = .Range("C" & .Rows.Count).End(xlUp).Row
For r = LR To 2 Step -1
With .Range("C" & r)
If .Value > 5 Then
AutoFilter is another possibility and may be considerably quicker depending on the number of rows of data.