Sub Concateneraddition()
Set plage = Application.InputBox(prompt:="Choisissez un champ à concatener", Type:=8)
contenu = "="
For Each cellule In plage: contenu = contenu & "+" & cellule: Next cellule
ActiveCell.Formula = Replace(contenu, ",", ".")
End Sub