Ci-joint, un code qui simule les étapes que vous devriez vérifier dans le vôtre :
Option Explicit
Public mes() As Variant
Sub Test()
Dim I As Integer, J As Integer
Dim Indic As Integer, NbLignes As Integer, MaxA2 As Integer
Dim AireTest As Range
Set AireTest = Range("t_Essai")
MaxA2 = Range("A2")
With AireTest
ReDim mes(.Rows.Count - 1, .Columns.Count - 1)
For I = 1 To .Rows.Count
For J = 1 To .Columns.Count
mes(I - 1, J - 1) = .Cells(I, J)
Next J
Next I
End With
For Indic = LBound(mes, 1) To UBound(mes, 1)
If mes(Indic, 2) >= MaxA2 Then
mes(Indic, 4) = 1
Else
mes(Indic, 4) = 0
End If
Next Indic
For Indic = LBound(mes, 1) To UBound(mes, 1)
Debug.Print mes(Indic, 0) & ", " & mes(Indic, 2) & ", " & mes(Indic, 4)
Next Indic
End Sub