Thank you guys

When I change to English syntax in VBA it turn up in Norwegian in the
worksheet

The sentence: ws.Cells(3, 2).Formula = "=SUMIF(B2:B7,B19,D2:D7)"

Turns up as: =SUMMERHVIS(B2:B7;B19;D2:D7) in cell B3

Dave:
This only a simplified example of what I am about to do. I do not need this
in B3

--
___________
Regards
JaydDe


JayDe skrev:

I have a problem

This is not working: ws.Cells(3, 2).Formula = "=SUMIF(B2:B7,B19,D2:D7)"

But this is working: ws.Cells(3, 2).Formula = "SUMIF(B2:B7,B19,D2:D7)"


The only difference is the "=" sign.
Can anyone help me?


I have a Norvegian Excel installation , and the Norwegian syntax is:

ws.Cells(3, 2).Formula = "=SUMMERHVIS(B2:B7;B19;D2:D7)"

but it is not working


___________
Regards
JaydDe