TableStyleElement Members (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Represents a single table style element.

Name

Description

Clear

Clears the formatting for this element.

Name

Description

Name

Description

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. Read-only.

Borders

Returns a Borders collection that represents the borders of a table style element. Read-only.

Creator

Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long.

Font

Returns a Font object that represents the font of the specified object. Read-only.

HasFormat

Returns whether a table style element has formatting applied to the specified element. Read-only Boolean.

Interior

Returns an Interior object that represents the interior of the specified object. Read-only.

Parent

Returns the parent object for the specified object. Read-only.

StripeSize

Returns or sets the size of banding. Read/write Long.

Show:
© 2016 Microsoft