Runtime error 1004
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
|