View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JayDe JayDe is offline
external usenet poster
 
Posts: 13
Default 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