Free Support Forum -

Value of a formula cell


How do I get the value of a cell which contains a formula?

If I use oSheet.Cells("G51").Value all I get is 0.0 as the value, instead of the calculated value of the formula.

Is there a way around this?

After you set formulas to cells, please call Excel.CalculateFormula method. Then you can retrieve the result of formulas.