>I have a table(Mytable) where one of the fields(myfield) contains a
>formula like ("=SUM(N2:N"+ALLTRIM(STR(lnLastRow))+")").
>
>When I run the code below with the "=" in front of "SUM" in Myfield,
>I get an OLE error(code 0x800a03ec: Unknown COM status code)
>
>Without "=", the code works fine.
>

>.Columns[1].Value =  Mytable.myfield 
>

>
>Any help?
>Thanks


Maybe try this:

* Use "=SUM(N2:N" + TRANSFORM(lnLastRow) + ")"
.Columns[1].FormulaR1C1 = myTable.myField