Quote Originally Posted by lucas
Why not just put the formula in with vba:
[vba]Sheets("01").Cells(4, 4).Formula = "=A1+B1"[/vba]
Also, when I try this, it inputs the formula as a formula - I think the OP wants to have it as text.