1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
| option explicit
Sub Macro1()
Dim t As Variant, t2() As String, X As Long, i As Long, k As Long, z As String
On Error Resume Next
Application.ScreenUpdating = False
Sheets("Hors délais").Range("a2:m" & Range("a65536").End(xlUp).Row).ClearContents
t = Sheets("Arrivée factures").Range("a3:m" & Range("a65536").End(xlUp).Row)
X = 1
For i = 1 To UBound(t)
If t(i, 13) > 10 Then
z = z & "facture n° " & t(i, 2) & Chr(10)
ReDim Preserve t2(1 To 13, 1 To X)
For k = 1 To 13
t2(k, X) = t(i, k)
Next k: X = X + 1: End If: Next i
Sheets("Hors délais").Range("a65536").End(xlUp)(2).Resize(UBound(t2, 2), UBound(t2, 1)) = Application.Transpose(t2)
Erase t, t2: MsgBox "Dépassement de délais pour la (les) facture(s) " & Chr(10) & z, vbInformation, "Avertissement"
End Sub |
Partager