Borders Object Members

Excel Developer Reference

A collection of four Border objects that represent the four borders of a Range or Style object.

Properties

	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 (you can use this property with an OLE Automation object to return the application of that object). Read-only.
	Color	Returns or sets the primary color of the object, as shown in the table in the remarks section. Use the RGB function to create a color value. Read/write Variant.
	ColorIndex	Returns or sets a Variant value that represents the color of all four borders.
	Count	Returns a Long value that represents the number of objects in the collection.
	Item	Returns a Border object that represents one of the borders of either a range of cells or a style.
	LineStyle	Returns or sets the line style for the border. Read/write XlLineStyle, xlGray25, xlGray50, xlGray75, or xlAutomatic.
	Parent	Returns the parent object for the specified object. Read-only.
	ThemeColor	Read/write
	TintAndShade	Read/write
	Value	Synonym for Borders.LineStyle.
	Weight	Returns or sets a XlBorderWeight value that represents the weight of the border.