If I enter this in VBA:
Ws.Cells(Rl, I).Formula = "=SUM(" & Chr(64 + I) & _
"10:" & Chr(64 + I) & (Rl - 1) & ")"
I get the following in the Excel Cell (if Rl is 140 and I is 11):
which seems just fine to me. However I get a #Name?-error displayed rather than the sum. Why is this?
If I then go to the cell in the Excel sheet and just click in the formula field and press the Enter-key, I get the correct value in the cell.
Iver in Oslo