With Sheets("RdV_transfert").Columns("h:h")
On Error Resume Next
.Find(What:="à confirmer", After:=ActiveCell, LookIn:=xlValues, LookAt _
:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _
False, SearchFormat:=False).Activate
.Offset(0, 1) = "=VALUE(LEFT(REPLACE(REPLACE(RC[-7],3,1,""/""),6,1,""/""),10))-RC[-6]"
.Offset(0, 2) = "Réseau : " & .Offset(0, -3) & Chr(10) & "Agent : " _
& " " & .Offset(0, -2) & Chr(10) & "Date RdV : " & " " & .Offset(0, -6) & Chr(10) _
& "Date Appel : " & " " & .Offset(0, -5) & Chr(10) & "Nbr jours entre : " & " " & .Offset(0, 1) _
& Chr(10) & Chr(10) & "ENVOI ? = OUI ou NON"
'MsgBox ActiveCell.Offset(0, 2)
If MsgBox(prompt:=.Offset(0, 2), Buttons:=vbQuestion + vbYesNo) <> vbNo Then
.Offset(0, 3) = "Envoi"
Else
.Offset(0, 3) = "Ne pas envoyer"
End If
.Offset(0, 1) = ""
.Offset(0, 2) = ""
End With
End Sub