>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:
.Columns[1].FormulaR1C1 = myTable.myField