Partager via

Range.Table Method

  • Article

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

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Function Table ( _
    RowInput As Object, _
    ColumnInput As Object _
) As Object
'Usage
Dim instance As Range
Dim RowInput As Object
Dim ColumnInput As Object
Dim returnValue As Object

returnValue = instance.Table(RowInput, _
    ColumnInput)

Object Table(
    Object RowInput,
    Object ColumnInput
)

Parameters

  • RowInput
    Type: System.Object

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

  • ColumnInput
    Type: System.Object

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

Return Value

Type: System.Object

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.

See Also

Reference

Range Interface

Range Members

Microsoft.Office.Interop.Excel Namespace