Value of a formula cell

mecED · October 19, 2005, 3:11am

Hi

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?

Laurence · October 19, 2005, 5:40am

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