ActiveX

To add a formula to a sheet

At run time,

1. Specify the Sheet if you have multiple sheets.
2. Specify the cell or cells to which you want to add a formula with the Col, Col2, Row, and Row2 properties as appropriate.
3. If you are selecting a block of cells, set the BlockMode property to True.
4. Define the formula with the Formula property.
5. If you selected a block of cells, set the BlockMode property back to False.