Application.GetCellInfo Method (Project)
Gets the cell object at the specified coordinates.
Syntax
expression .GetCellInfo(x, y)
expression A variable that represents an Application object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
x |
Required |
Long |
Horizontal coordinate on the grid. |
y |
Required |
Long |
Vertical coordinate on the grid. |
Return Value
Cell
Remarks
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.
Example
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