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