**Range(“<your range>”).Formula = <your formula>**

‘examples Range(“A1:B4”).Formula =(2+2)/4 Range(“C3:E3”).Formula = 10^2

Skip to content
# Tag: write formula to range

## What is the syntax to apply a formula to a range?

**Range(“<your range>”).Formula = <your formula>**

‘examples Range(“A1:B4”).Formula =(2+2)/4 Range(“C3:E3”).Formula = 10^2