Cell Object

  • Article
Application
Cell
Multiple objects

Represents the active cell. There is no collection for Cell objects. The Cell object can only be accessed through the ActiveCell property of the Application object.

Using the Cell Object

Use the ActiveCell property to return a Cell object. The following example displays the names of all the resources assigned to the task in the active cell.

Dim A As Assignment

For Each A In ActiveCell.Task.Assignments
    MsgBox A.ResourceName
Next A

Properties | Application Property | FieldID Property | FieldName Property | Parent Property | Resources Property | Task Property | Text Property

Parent Objects | Application Object

Child Objects | Resource Object, Resources Collection Object | Task Object, Tasks Collection Object

See Also | ActiveCell Property