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