Range.Table (Excel)

Creates a data table based on input values and formulas that you define on a worksheet.

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.

Table (RowInput, ColumnInput)

ActiveCell.Table

Arguments

Optional arguments

The following arguments are optional

RowInput - A single cell to use as the row input for your table

ColumnInput (Single) - A single cell to use as the column input for your table.