Add Method (Cells, Rows, and Columns Collections)

See Also         Example         Applies To

Adds a cell, row, or column to a table.

Syntax 1

expression.Add(BeforeCell)

Syntax 2

expression.Add(BeforeColumn)

Syntax 3

expression.Add(BeforeRow)

expression   Required. An expression that returns a Cells object (Syntax 1), Columns object (Syntax 2), or Rows object (Syntax 3).

BeforeCell   Optional Variant. A Cell object that represents the cell that will appear immediately to the right of the new cell or cells.

BeforeColumn   Optional Variant. A Column object that represents the column that will appear immediately to the right of the new column.

BeforeRow   Optional Variant. A Row object that represents the row that will appear immediately below the new row.