If Cells(x, "J")[B].Text[/B] = "" And Cells(x, "K")[B].Text[/B] = "" Then
If not Cells(x, "J").text like "#" And Not Cells(x, "K").text like "#" Then
If [COLOR=Red]Not[/COLOR] Cells(x, "J")[B].Text[/B] = "" And Cells(x, "K")[B].Text[/B] = "" Then
If not Cells(x, "J").text like "#" And Not Cells(x, "K").text like "#" Then
If Not Cells(x, "J").Text = "" And Cells(x, "K").Text = "" Then
If Not Cells(x, "J").Text = "" then
if Cells(x, "K").Text = "" Then msgbox "la cellule " & cells(x,"K").address & " est vide.": Exit For 'si tu ne veux pas continuer les tests .
end if
cells(15.52,"j")
For i = 15 To 52
If F1.Cells(i, "J").Value <> "" And _
F1.Cells(i, "K").Value = "" Then _
MsgBox "la cellule " & Cells(i, "K").Address & " est vide." ': Exit For 'si tu ne veux pas continuer les tests .
Next i