Notitie
Voor toegang tot deze pagina is autorisatie vereist. U kunt proberen u aan te melden of de directory te wijzigen.
Voor toegang tot deze pagina is autorisatie vereist. U kunt proberen de mappen te wijzigen.
Returns a CellRange object that represents a range of cells in a table.
Syntax
expression.Cells (StartRow, StartColumn, EndRow, EndColumn)
expression A variable that represents a Table object.
Parameters
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| StartRow | Optional | Long | The row in which the starting cell exists. If this argument is omitted, all the table rows are included in the range. |
| StartColumn | Optional | Long | The column in which the starting cell exists. If this argument is omitted, all the table columns are included in the range. |
| EndRow | Optional | Long | The row in which the ending cell exists. If this argument is omitted, only the row specified by StartRow is included in the range. If this argument is specified but StartRow is omitted, an error occurs. |
| EndColumn | Optional | Long | The column in which the ending cell exists. If this argument is omitted, only the column specified by StartColumn is included in the range. If this argument is specified but StartColumn is omitted, an error occurs. |
Remarks
If all arguments are omitted, all the cells in the table are included in the range.
Example
This example merges the first two cells in the first two rows of the specified table.
Sub MergeCells()
ActiveDocument.Pages(1).Shapes(2).Table _
.Cells(StartRow:=1, StartColumn:=1, _
EndRow:=2, EndColumn:=2).Merge
End Sub
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.