Selection.InsertFormula (Word)

Inserts an = (Formula) field that contains a formula at the selection.

The formula replaces the selection, if the selection is not collapsed. If you are using a spreadsheet application, such as Microsoft Office Excel, embedding all or part of a worksheet in a document is often easier than using the = (Formula) field in a table. The Formula argument is optional only if the selection is in a cell and there is at least one cell that contains a value above or to the left of the cell that contains the insertion point. If the cells above the insertion point contain values, the inserted field is {=SUM(ABOVE)}; if the cells to the left of the insertion point contain values, the inserted field is {=SUM(LEFT)}. If both the cells above the insertion point and the cells to the left of it contain values, Microsoft Word uses the following rules to determine which SUM function to insert:

InsertFormula (Formula, NumberFormat)

Set MyRange = ActiveDocument.Range(0, 0) 
Set myTable = ActiveDocument.Tables.Add(MyRange, 3, 3) 
With myTable 
 .Cell(1, 1).Range.InsertAfter "100" 
 .Cell(2, 1).Range.InsertAfter "50" 
 .Cell(3, 1).Select 
End With 
Selection.InsertFormula Formula:="=Average(Above)"

Arguments

Optional arguments

The following arguments are optional

Formula (String) - The mathematical formula you want the = (Formula) field to evaluate. Spreadsheet-type references to table cells are valid. For example, "=SUM(A4:C4)" specifies the first three values in the fourth row. For more information about the = (Formula) field, see Field codes:= (Formula) field.

NumberFormat (String) - A format for the result of the = (Formula) field. For information about the types of formats you can apply, see Numeric Picture (#) field switch.