![](https://cdn-0.access-excel.tips/wp-content/uploads/2014/12/feature_excel_vba-150x150.jpg)
This Excel VBA tutorial explains how to use Formula Property in Excel VBA.
Formula Property in Excel VBA
There are two functions for Formula Property:
1. To set formula in a Range, like the way you type a formula in worksheet
2. To retrieve formula from a Range
Syntax of Formula Property
To set a formula:
Range.Formula = "=your formula"
To retrieve a formula:
variableName = Range.Formula
Remarks
You can also set a formula using Value Property
Range.Value = "=your formula"
...
Read More