Bonjour,
Sub surut_ress()
Dim Resfind As Variant
Dim Cel As Range
Set Resfind = Cells.Find(What:="% MAX", LookIn:=xlValues, lookat:=xlWhole)
If Not Resfind Is Nothing Then
For Each Cel In Range(Resfind.Offset(1, 0), Resfind.End(xlDown))
If Application.Max(Range(Cells(Cel.Row, "R"), Cells(Cel.Row, "AG"))) > Cel.Value Then
MsgBox "Dépassement de la ressource " & Cel.Offset(0, -1)
End If
Next Cel
End If
Set Resfind = Nothing
End Sub
A+