I'm getting the 'object required' error on the red line of code. Any debugging tips?
For Each cell In rngtest If cell.Value = linenumber Then cell.EntireRow.Delete Shift:=xlUp End If If cell.Interior.Color = 65535 Then cell.Resize(1, 20).Select Selection.Interior.Color = 65535 End If Next
Bookmarks