ListColumn Object Members

  • Article
Excel Developer Reference

Represents a column in a table.

Methods

  Name Description
Bb242346.methods(en-us,office.12).gif Delete Deletes the column of data in the list.

Properties

  Name Description
Bb242346.properties(en-us,office.12).gif Application When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only.
Bb242346.properties(en-us,office.12).gif DataBodyRange Read-only
Bb242346.properties(en-us,office.12).gif Index Returns a Long value that represents the index number of the ListColumn object within the ListColumns collection.
Bb242346.properties(en-us,office.12).gif Name Returns or sets a String value that represents the name of the list column.
Bb242346.properties(en-us,office.12).gif Parent Returns the parent object for the specified object. Read-only.
Bb242346.properties(en-us,office.12).gif Range Returns a Range object that represents the range to which the specified list object in the above list applies.
Bb242346.properties(en-us,office.12).gif Total Read-only
Bb242346.properties(en-us,office.12).gif TotalsCalculation Determines the type of calculation in the Totals row of the list column based on the value of the XlTotalsCalculation enumeration. Read/write.
Bb242346.properties(en-us,office.12).gif XPath Returns an XPath object that represents the Xpath of the element mapped to the specified Range object. The context of the range determines whether or not the action succeeds or returns an empty object. Read-only.