Sub Hyper()
Dim Bat$, App$, Loc$, Ents$, DPnum$, NomFichierPDF As String
DPnum = Sheets("Récap DP").Range("T2", .Range("T2").End(xlDown))
Loc = Sheets("Récap DP").Range("I2", .Range("I2").End(xlDown))
Ents = Sheets("Récap DP").Range("O2", .Range("O2").End(xlDown))
App = Sheets("Récap DP").Range("G2", .Range("G2").End(xlDown))
Bat = Sheets("Récap DP").Range("H2", .Range("H2").End(xlDown))
NomFichierPDF = "C:\DP\" & Bat & "\" & App & "\" & "DP " & DPnum & " " & Loc & " " & Ents & ".pdf"
ActiveCell.Hyperlinks.Add _
Anchor:=Range("X" & [X65000].End(xlDown).Row + 0), _
Address:=NomFichierPDF, _
TextToDisplay:=DPnum
ActiveCell = [X60000].End(xlDown).Row
End Sub