Table.AutoFormat(Object, Object, Object, Object, Object, Object, Object, Object, Object, Object) Table.AutoFormat(Object, Object, Object, Object, Object, Object, Object, Object, Object, Object) 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);
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 Object

Optional Object.

ApplyBorders
Object Object

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

ApplyShading
Object Object

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

ApplyFont
Object Object

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

ApplyColor
Object Object

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

ApplyHeadingRows
Object Object

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

ApplyLastRow
Object Object

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

ApplyFirstColumn
Object Object

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

ApplyLastColumn
Object Object

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

AutoFit
Object 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