Sub Test()
Dim Nlig&, nCol&, xrg As Range, T
T = Timer: Application.ScreenUpdating = False
With Sheets("Feuil1")
.Rows.Hidden = False
Nlig = .Cells(.Rows.Count, "a").End(xlUp).Row
If Nlig = 1 Then Exit Sub
nCol = .UsedRange.Column + .UsedRange.Columns.Count
With .Rows("2:" & Nlig)
.Columns(nCol).FormulaLocal = "=(1/(u2<>v2))"
On Error Resume Next
Set xrg = .Columns(nCol).SpecialCells(xlCellTypeFormulas, 16)
On Error GoTo 0
If Not xrg Is Nothing Then xrg.EntireRow.Hidden = True
.Columns(nCol).Delete
End With
Application.Goto [a1], True
End With
MsgBox Round((Timer - T), 2) & " sec."
End Sub