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)



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.