Table.AutoFormat Method

Definition

Applies a predefined look to a table.

public void AutoFormat (ref object Format, ref object ApplyBorders, ref object ApplyShading, ref object ApplyFont, ref object ApplyColor, ref object ApplyHeadingRows, ref object ApplyLastRow, ref object ApplyFirstColumn, ref object ApplyLastColumn, ref object AutoFit);
abstract member AutoFormat : obj * obj * obj * obj * obj * obj * obj * obj * obj * obj -> unit
Public Sub AutoFormat (Optional ByRef Format As Object, Optional ByRef ApplyBorders As Object, Optional ByRef ApplyShading As Object, Optional ByRef ApplyFont As Object, Optional ByRef ApplyColor As Object, Optional ByRef ApplyHeadingRows As Object, Optional ByRef ApplyLastRow As Object, Optional ByRef ApplyFirstColumn As Object, Optional ByRef ApplyLastColumn As Object, Optional ByRef AutoFit As Object)

Parameters

Format
Object

Optional Object.

ApplyBorders
Object

Optional Object. True to apply the border properties of the specified format. The default value is True.

ApplyShading
Object

Optional Object. True to apply the shading properties of the specified format. The default value is True.

ApplyFont
Object

Optional Object. True to apply the font properties of the specified format. The default value is True.

ApplyColor
Object

Optional Object. True to apply the color properties of the specified format. The default value is True.

ApplyHeadingRows
Object

Optional Object. True to apply the heading-row properties of the specified format. The default value is True.

ApplyLastRow
Object

Optional Object. True to apply the last-row properties of the specified format. The default value is False.

ApplyFirstColumn
Object

Optional Object. True to apply the first-column properties of the specified format. The default value is True.

ApplyLastColumn
Object

Optional Object. True to apply the last-column properties of the specified format. The default value is False.

AutoFit
Object

Optional Object. True to decrease the width of the table columns as much as possible without changing the way text wraps in the cells. The default value is True.

Remarks

The arguments for this method correspond to the options in the Table AutoFormat dialog box (Table menu).

Applies to