When I write formula in code, the formulae sometimes do not resolve to the result in the worksheet. They display as the formula.
For example, if I use:
cells(1,1).formula = "=A5", the value "=A5" appears in the cell, rather than the result, which is the value of cell A5
cells(1,1).formula = "=(A5+A10+A15)", same thing happens.
However, when I can see the spreadsheet, and cut the formula and paste it straight back in, it resolves properly.
Do I have to tell it to recalculate or something? What am I doing wrong?