ActiveX
To add a formula to a sheet
At run time,
- Specify the Sheet if you have multiple sheets.
- Specify the cell or cells to which you want to add a formula with the Col, Col2, Row, and Row2 properties as appropriate.
- If you are selecting a block of cells, set the BlockMode property to True.
- Define the formula with the Formula property.
- If you selected a block of cells, set the BlockMode property back to False.