Table of contents
TOC
Collapse the table of content
Expand the table of content

Application.GetCellInfo Method (Project)

office 365 dev account|Last Updated: 6/12/2017
|
1 Contributor

Gets the cell object at the specified coordinates.

Syntax

expression. GetCellInfo( ** x, ** y )

expression A variable that represents an Application object.

Parameters

NameRequired/OptionalData TypeDescription
xRequiredLongHorizontal coordinate on the grid.
yRequiredLongVertical 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 
© 2018 Microsoft