Re : Insérer VLOOKUP en VBA
Ok, j'ai trouvé l'astuce :
Sub TEST()
Dim Guill As String
Guill = """"
Dim Name As String
Name = Guill & "Alain" & Guill
Worksheets("Sheet1").Cells(1, 1) = "=2+3"
Worksheets("Sheet1").Cells(2, 1) = "VLOOKUP(" & Name & ";$A$5:$B$7;2;false)"...