Creates a data table based on input values and formulas that you define on a worksheet.
Syntax
expression.Table(RowInput, ColumnInput)
expression Required. An expression that returns an object in the Applies To list.
RowInput Optional Variant. A single cell to use as the row input for your table.
ColumnInput Optional Variant. A single cell to use as the column input for your table.
Remarks
Use data tables to perform a what-if analysis by changing certain constant values on your worksheet to see how values in other cells are affected.