Range.Table Method
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.ObjectOptional Object. A single cell to use as the row input for your table.
ColumnInput
Type: System.ObjectOptional 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.