ListObject.Range Property

Reference

Definition

Namespace:: Microsoft.Office.Tools.Excel

Assemblies:: Microsoft.Office.Tools.Excel.dll, Microsoft.Office.Tools.Excel.v4.0.Utilities.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Gets a Range that represents the range to which the ListObject applies.

public:
 property Microsoft::Office::Interop::Excel::Range ^ Range { Microsoft::Office::Interop::Excel::Range ^ get(); };

public Microsoft.Office.Interop.Excel.Range Range { get; }

member this.Range : Microsoft.Office.Interop.Excel.Range

Public ReadOnly Property Range As Range

Property Value

Range

A Range that represents the range to which the ListObject applies.

Examples

The following code example creates a ListObject and then displays a message showing how many cells are in the range to which the ListObject applies.

This example is for a document-level customization.

private void ListObject_Range()
{
    Microsoft.Office.Tools.Excel.ListObject list1 =
        this.Controls.AddListObject(
        this.Range["A1", "C4"], "list1");

    MessageBox.Show("The list object contains " +
        list1.Range.Cells.Count.ToString() + " cells.");
}

Private Sub ListObject_Range()
    Dim List1 As Microsoft.Office.Tools.Excel.ListObject = _
        Me.Controls.AddListObject(Me.Range("A1", "C4"), "List1")

    MessageBox.Show("The list object contains " & _
        List1.Range.Cells.Count.ToString() & " cells.")
End Sub

Remarks

Includes the header, Insert row and Totals row if displayed.

Applies to

通过