Sub Remplir1()
ThisWorkbook.Names.Add "X", "<img class=""img_info"" src=""images/µ.jpg"" class=""img_ville"" width=""400"" height=""300"" id=""µµ"" style=""display:none;"">"
With Range("F5:F" & Range("A" & Rows.Count).End(xlUp).Row)
.FormulaR1C1 = "=SUBSTITUTE(SUBSTITUTE(X,""µµ"",""img""&ROW()-4),""µ"",TRIM(SUBSTITUTE(RC1,"""""""",)))"
.Value = .Value
End With
End Sub
Sub Remplir2()
ThisWorkbook.Names.Add "Y", "<g><a xlink:href=""µ.html"" target=""myFrame"" onmouseover=""afficher_image('µµ');"" onmouseout=""cacher_image('µµ');"">"
With Range("F5:F" & Range("A" & Rows.Count).End(xlUp).Row)
.FormulaR1C1 = "=SUBSTITUTE(SUBSTITUTE(Y,""µµ"",""img""&ROW()-4),""µ"",TRIM(SUBSTITUTE(RC1,"""""""",)))"
.Value = .Value
End With
End Sub