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