[COLOR=blue]Sub[/COLOR] test2()
[COLOR=blue]Dim[/COLOR] Fl [COLOR=blue]As String[/COLOR], Clsr [COLOR=blue]As String[/COLOR], Cel [COLOR=blue]As String[/COLOR]
Fl = "Feuil1": Clsr = "[Classeur1]": Cel = "R[4]C1"
Range("A4:A65").FormulaR1C1 = "=IF('" & Clsr & Fl & "'!" & Cel & "="""","""",'" & Clsr & Fl & "'!" & Cel & ")"
[COLOR=blue]End Sub[/COLOR]