VBA convert my comma number to formula separator

[Eraaz]

Hello,

I try to make a formula in vba and I have a problem.
For example in cell C2 I have a decimal number "4,62" and when I try to use it in a formula, VBA take the comma as a separator.

Sheets("Feuil4").Range("C3").Formula = "=SUM(" & Range("C2") & ",[@[Prix total ens]])"

If @[Prix total ens] = 5, the final result will be 71.
How can I make the comma read as a comma and not a separator ?

Btw I'm French so I know that for most of you, you will written 4.62
Thanks.

 

[offthelip]

you could try something like this:

Dim txt As String
txt = Range("C2")
txt = Replace(txt, ",", ".")
Sheets("Feuil4").Range("C3").Formula = "SUM(" & txt & ",[@[Prix total ens]])"

Note I can't test it as I am in the UK

 

[Eraaz]

Sheets("Feuil4").Range("C3").Formula = Range("C3").Formula = "=SUM(C2,[@[Prix total ens]])"

Someone helped me