Option Explicit
Sub EnregistrerFacture()
Dim c As Range, NoDevis As Range, Ligne As Integer
Dim Bdd As Worksheet, Fact As Worksheet
Set Bdd = Worksheets("BDD-CHANTIERS")
Set Fact = Worksheets("facture(3)")
Set NoDevis = Fact.Range("C15")
Set c = Range("T_DEVISS[N°Devis]").Find(what:=NoDevis.Value, LookAt:=xlWhole)
If Not c Is Nothing Then
Ligne = c.Row ' n° de ligne du devis
Bdd.Cells(Ligne, 34) = Fact.Range("c14")
Bdd.Cells(Ligne, 35) = Fact.Range("c15")
Bdd.Cells(Ligne, 36) = Fact.Range("g51")
'faire la suite
Else
MsgBox "N° devis " & NoDevis & " non trouvé!"
End If
Set Bdd = Nothing
Set Fact = Nothing...