Hello everyone, I am new in the forum and this is already my second question. I need your help with this other issue.

I am comparing two columns in the same sheet. The columns have the same number of rows and what I need is:

If B6=E6 then erase the row 6. I wrote a code and it is working perfectly. BUT it is really slow. I would like to know if there is any way to improve the code in order to reduce the time of response. The code is:

Range("E1").Select
Selection.End(xlDown).Select
While ActiveCell.Value <> ""
ValorE = ActiveCell.Value
ValorB = ActiveCell.Offset(0, -3).Value

If ValorE = ValorB Then
Selection.EntireRow.Delete
Else
ActiveCell.Offset(1, 0).Select
End If
Wend

I am sure you can help me with this guys. Thanks

Cheers
Ed