Error when inserting formula into excel via VBA

[Kronix]

So I insert "=SUMME(F2:F254)" into a cell in Excel. When I go to Excel it shows #NAME? in the cell instead of the sum. But when I click on the cell to edit it and then leave the cell without changing anything, the formula suddenly works and it shows the sum. How do I make the formula work from the beginning?

 

[Minty]

So how are you inserting it? Code please.

 

[Kronix]

I tried

xlws.Cells(reccount + 2, "F").Formula = "=SUM(F2:F254)"

and

xlws.Cells(reccount + 2, "F").Value = "=SUM(F2:F254)"

Do I need some kind of formatting to tell it that the string should be treated as a formula? You'd think using the Formula attribute would handle things by itself.

 

[Kronix]

Nevermind, I found the problem. I was using the foreign language version of the SUM function when assigning the string in VBA code. It keeps turning up that VBA code always requires English versions of functions, which is quite frustrating when even SQL functions must be written in the foreign language.

 

[Minty]

I think you may need to create the formula string first, and use the Range() method something like

strExcel = "=SUM(F2:F254)"

xlws.Range(reccount + 2, "F").Formula = strExcel

More detail from here https://stackoverflow.com/questions/13123230/writing-formula-into-excel-through-access-vba

 

[Minty]

Posts crossed in the ether!

Glad you solved it.