Sub Macro3()
'
' Macro3 Macro
'
'
'
Range("A8").Select
nblignes = Application.WorksheetFunction.CountA(Range("a:a")) - 3
For i = 1 To nblignes
Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
Call Patch_Contrainte
ActiveCell.Offset(0, 1).Select
Next i
End Sub