Sub RegroupeLigneS()
....
For ligne = 4 To nlig
crit = f1.Cells(ligne, 1)
d1(crit) = ""
ligT = Application.Match(crit, d1.keys, 0)
For col = 1 To ncol
If f1.Cells(ligne, col) <> "" And (f2.Cells(ligT, col) = "FER" Or f2.Cells(ligT, col) = "CP" Or f2.Cells(ligT, col) =...