If Range("E17")="" then
Range("A1")=""
Else
Range("A1")="a"
EndIf
Option Explicit
Sub Test()
Dim resultat As String
If Not ActiveSheet.Range("E17").Value = "" Then resultat = "a"
MsgBox resultat
End Sub
Sub Essai()
[A1] = IIf([E17] = "", "", "a")
End Sub
Bonjour Soan,Bonjour farid, le fil,
Si la formule est en A1, code VBA :
soanVB:Sub Essai() [A1] = IIf([E17] = "", "", "a") End Sub