cells.formula

[lezawang]

Hi
Why I need cells.formula when I can do it without cells.formula as following:

Sub cell_formula()
    Workbooks(1).Worksheets(1).Cells(1, 1).Value = "=sum(c1+c2)"
End Sub

Thank you so much.

 

[sheetspread]

To print a string preceded by the = sign that Excel interprets as a formula, yes, either .formula or .value will work. Sometimes, however, you may wish to distinguish between types:

Excel 2010
	C
1	3
2	4
3
4
5	7
Sheet3

Cell Formulas
Range	Formula
C5	=SUM(C1+C2)

Sub formulavsvalue()
[c7] = Left([c5].Formula, 1)
[c8] = Left([c5].Value, 1)
End Sub

Excel 2010
	C
1	3
2	4
3
4
5	7
6
7	=
8	7
Sheet3

Cell Formulas
Range	Formula
C5	=SUM(C1+C2)