Diese Dokumentation wurde archiviert und wird nicht länger gepflegt.

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)

Dim RowInput As Object
Dim ColumnInput As Object
Dim returnValue As Object
Dim range1 As Range
returnValue = range1.Table(RowInput, ColumnInput)

object Table(
	[In, Optional] object RowInput, 
	[In, Optional] object ColumnInput
public System.Object Table(
	/*in*/System.Object RowInput, 
	/*in*/System.Object ColumnInput
function Table(
	 RowInput : Object, 
	 ColumnInput : Object
) : Object;



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


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

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.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms