UserForm1.Show
Dim c As Range
With Sheets("Grille_de_Dispensation").Range("A1:K" & Sheets("Grille_de_Dispensation").Range("A" & Rows.Count).End(xlUp).Row)
Set c = .Find("", .Cells(.Rows.Count, .Columns.Count), xlFormulas)
If Not c Is Nothing Then MsgBox " Le Patient Code " & .Range("A" & c.Row) & Chr(13) & Chr(10) & "N°" & .Range("M" & c.Row) & _
" a des informations manquantes !" & Chr(13) & Chr(10) & " Veuillez Rechercher et corriger", 64
End With