Range.ConvertToTable Method

  • Article
Word Developer Reference

Converts text within a range to a table. Returns the table as a Table object.

Syntax

expression.ConvertToTable(Separator, NumRows, NumColumns, InitialColumnWidth, Format, ApplyBorders, ApplyShading, ApplyFont, ApplyColor, ApplyHeadingRows, ApplyLastRow, ApplyFirstColumn, ApplyLastColumn, AutoFit, AutoFitBehavior, DefaultTableBehavior)

expression   A variable that represents a Range object.

Parameters

Name Required/Optional Data Type Description
Separator Optional Variant Specifies the character used to separate text into cells. Can be a character or one of the following WdTableFieldSeparator constant. If this argument is omitted, the value of the DefaultTableSeparator property is used.
NumRows Optional Variant The number of rows in the table. If this argument is omitted, Microsoft Word sets the number of rows, based on the contents of the range.
NumColumns Optional Variant The number of columns in the table. If this argument is omitted, Word sets the number of columns, based on the contents of the range.
InitialColumnWidth Optional Variant The initial width of each column, in points. If this argument is omitted, Word calculates and adjusts the column width so that the table stretches from margin to margin.
Format Optional Variant Specifies one of the predefined formats listed in the Table AutoFormat dialog box. Can be one of the WdTableFormat constants.
ApplyBorders Optional Variant True to apply the border properties of the specified format.
ApplyShading Optional Variant True to apply the shading properties of the specified format.
ApplyFont Optional Variant True to apply the font properties of the specified format.
ApplyColor Optional Variant True to apply the color properties of the specified format.
ApplyHeadingRows Optional Variant True to apply the heading-row properties of the specified format.
ApplyLastRow Optional Variant True to apply the last-row properties of the specified format.
ApplyFirstColumn Optional Variant True to apply the first-column properties of the specified format.
ApplyLastColumn Optional Variant True to apply the last-column properties of the specified format.
AutoFit Optional Variant True to decrease the width of the table columns as much as possible without changing the way text wraps in the cells.
AutoFitBehavior Optional Variant Sets the AutoFit rules for how Word sizes a table. Can be one of the following WdAutoFitBehavior constant. If DefaultTableBehavior is wdWord8TableBehavior, this argument is ignored.
DefaultTableBehavior Optional Variant Sets a value that specifies whether Microsoft Word automatically resizes cells in a table to fit the contents (AutoFit). Can be one of the WdDefaultTableBehavior constant.

Return Value
Table

Example

This example inserts text at the insertion point and then converts the comma-delimited text to a table with formatting.

Visual Basic for Applications 
  With Selection
    .Collapse
    .InsertBefore "one, two, three"
    .InsertParagraphAfter
    .InsertAfter "one, two, three"
    .InsertParagraphAfter
End With
Set myTable = Selection.ConvertToTable( _
    Separator:=wdSeparateByCommas, _
    Format:=wdTableFormatList8)

See Also