Formula added to cell with macro will not update until cell is entered

[SweKenZo]

Hi,

I am not sure how to put this. First time posting here, but been Reading ALOT!

What im trying to pull off:


i = 7

Do
If i / 2 > Int(i / 2) Then
Rows(i).Interior.ColorIndex = 15
End If

i = i + 1
Loop Until Sheets("MängderTest").Cells(i, 1).Value = ""

Range("C" & i).NumberFormat = "General"
Range("C" & i).Formula = "=SUMMA(C7:C" & i - 1 & ")"

I want to add a formula to the first free cell in the C column. when i run the macro get #NAME.
I then select the cell and the formula is there '=SUM(C7:C11)'
If I double click the cell and selects another cell the value of the formula will appear.

Do you know any tricks around this? Ive tried changing the format of the cell but with no success.


Many thanks in advance!

//Kenny

 

[skywriter]

What's SUMMA is that a UDF or something new to Excel, I'm using 2010 and I don't have it?

"=SUMMA(C7:C" & i - 1 & ")"

 

[SweKenZo]

Sorry, i forgot to mention that I use a Swedish version of excel 2010. SUMMA is the same as SUM.

 

[SweKenZo]

Sheets("Fördelning").Cells(c, 3).Select
SendKeys "{F2}"
SendKeys "{Enter}"

This almost does it. But it only works for one cell. If I put it in a loop - it only works the last cell in the loop.

Any ideas?

 

[SweKenZo]

Still nothing?