編輯

共用方式為


Range.Table(Object, Object) Method

Definition

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

public object Table (object RowInput, object ColumnInput);
Public Function Table (Optional RowInput As Object, Optional ColumnInput As Object) As Object

Parameters

RowInput
Object

Optional Object. A single cell to use as the row input for your table.

ColumnInput
Object

Optional Object. A single cell to use as the column input for your table.

Returns

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.

Applies to