chamster
10-11-2007, 11:54 PM
The code itself is not finished yet. I'm posting it for the examples sake only. Please note - the error is NOT with incompleteness of the formula, even if it might seems so.
I'm trying the following code
.Cells(i, dSpan + 2).Formula = "=SUM.IF(" & "" & Chr(34) & ">0" & Chr(34) & ")"
and it executes fine (as in: i can compile and put that stuff in the cell). The fact that it gives error as the value matters not.
Then i change that to
.Cells(i, dSpan + 2).Formula = "=SUM.IF(" & "A" & Chr(34) & ">0" & Chr(34) & ")"
i.e. put in a capital A and guess what - the compiler doesn't like it anymore... What's up with that?!
I'm trying the following code
.Cells(i, dSpan + 2).Formula = "=SUM.IF(" & "" & Chr(34) & ">0" & Chr(34) & ")"
and it executes fine (as in: i can compile and put that stuff in the cell). The fact that it gives error as the value matters not.
Then i change that to
.Cells(i, dSpan + 2).Formula = "=SUM.IF(" & "A" & Chr(34) & ">0" & Chr(34) & ")"
i.e. put in a capital A and guess what - the compiler doesn't like it anymore... What's up with that?!