Sub suplignes()
Application.ScreenUpdating = False
fin = Cells.Find("*", , , , xlByRows, xlPrevious).Row
For i = fin To 1 Step -1
If NbvalJB(Cells(i, 1).Resize(, 7)) = 0 Then Rows(i).Delete
Next i
End Sub
Function NbvalJB(champ As Range)
a = champ
For Each c In a
If c <> "" Then n = n + 1
Next c
NbvalJB = n
End Function
Sub es()
Dim t(), t1(), x As Long, i As Long, y As Long, z As Byte
t = Range("a1:g" & Cells.Find("*", , , , , xlPrevious).Row).Value
ReDim t1(1 To UBound(t), 1 To 7)
For i = 1 To UBound(t)
For z = 1 To 7
If t(i, z) <> "" Then
x = x + 1
For y = 1 To 7: t1(x, y) = t(i, y): Next y
Exit For: End If: Next z: Next i
[a1:g10000].Clear
[A1].Resize(x, 7) = t1
End Sub
Sub Essai()
Set f2 = Sheets("feuil2")
a = [A3:G1000].Value
For k = 1 To 7
Set d = CreateObject("scripting.dictionary")
For i = 3 To UBound(a)
If a(i, k) <> "" Then d(CStr(i)) = a(i, k)
Next i
f2.Cells(2, k).Resize(d.Count) = Application.Transpose(d.items)
Next k
End Sub