Table.AutoFormat Method
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
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 -> unitPublic 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).