Formula from VBA to Excel worksheet

[Lars Kofod]

How do I get this formula from VBA into a cell in an
Excell worksheet.

Code first.
sVSTid = Cells(lRaekke, 7).Address
sHvis = "=+hvis($i$23>0;$i$23*" & sVSTid
sVSLoen = Cells(lRaekke, 22).Address
sEllers = ";" & sVSLoen & ")"
sSumFormel = sHvis & sEllers
Debug.Print sSumFormel

It gives this formula: =+hvis($i$23>0;$i$23*$G$46;$V$46)
(danish IF-function)
It keeps failing me no matter what I do. So I must do
something wrong.

Please help me
Lars Kofod

 

[Oliver Kharraz]

Hi,

VBA is US-centric. Use "," instead of ";"

Cheers,

Olivers

 

[Tom Ogilvy]

cells(1,1).FormulaLocal = sSumFormel