Application.GetCellInfo method (Project)
Gets the cell object at the specified coordinates.
expression. GetCellInfo( _x_, _y_ )
expression A variable that represents an Application object.
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| x | Required | Long | Horizontal coordinate on the grid. |
| y | Required | Long | Vertical coordinate on the grid. |
Cell
The coordinates x=0, y=0 specify the top-left corner of the grid. The coordinate value increases to the right for x coordinates and down for y coordinates. The value of x must be less than or equal to the number of columns in the view. The value of y must be less than or equal to the number of rows in the view.
The following example sets the cell at x=1, y=0 to red.
Dim c As Cell
Set c = Application.GetCellInfo(1, 0)
c.CellColor = pjRed
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.