Sub Ajouter()
Dim c As Range
With Sheets("INTERFACE")
If .[B5] = "" Then Exit Sub
Set c = Sheets("DEVIS").Cells.Find(Replace(.[B5], "_", "*"), , xlValues, xlPart)
If c Is Nothing Then Exit Sub
Do
Set c = c(2, 1)
If c.Interior.ColorIndex <> xlNone Then Exit Sub
Loop While c <> ""
c = .[D5]
c(1, 2) = .[D8]
c(1, 3) = .[B14]
c(1, 4) = .[D14]
c(1, 5) = .[D11]
c(1, 6) = c(1, 4) * c(1, 5)
End With
End Sub