TABLE macro

Equivalent to clicking the Table command on the Data menu. Creates a table based on the input values and formulas you define on a worksheet. Use data tables to perform a "what-if" analysis by changing certain constant values in your workbook to see how values in other cells are affected.

Syntax

TABLE(row_ref, column_ref)

TABLE?(row_ref, column_ref)

Row_ref    specifies the one cell to use as the row input for your table.

 

Column_ref    specifies the one cell to use as the column input for your table. Column_ref is subject to the same restrictions as row_ref.

Return to index