Sub TransfertQtéFicheTechn()
Dim wB1 As Workbook, wB2 As Workbook
Dim Plg As Range, dL As Long
If Range("g3") = 0 Then
MsgBox "Aucune denrée saisie....", , "Erreur"
Exit Sub
End If
Application.ScreenUpdating = False
Set wB1 = ThisWorkbook
With wB1.Sheets("FICHE TECHNIQUE")
Set Plg = .Range("CK17:CU" & .Range("CK32").End(xlUp).Row)
End With
Set wB2 = ("C:\ARCHIVES DONNEES FICHES TECHNIQUES\DonnéesFichesTechniques.xls.xlsx")
With wB2.Sheets("Archives")
dL = .Range("A65536").End(xlUp).Row + 1
.Range("M" & dL) = "Sauvegarde du " & Format(Date, "dd-mm-yyyy") & " à " & Time
For i = 1 To Plg.Rows.Count
If Application.CountA(Plg.Rows(i)) <> 0 Then
dL = dL + 1
.Range("A" & dL).Resize(1, Plg.Columns.Count) = Plg.Rows(i).Value
End If
Next
.Columns("A:L").AutoFit
End With
wB2.Close True
Application.ScreenUpdating = True
End Sub