Share via

Application.ActiveCell Property

  • Article
Project Developer Reference

Returns a Cell object that represents the active cell. Read-only Object.

Syntax

expression.ActiveCell

expression   A variable that represents an Application object.

Return Value
Cell

Example
The following example displays the name of the resources assigned to the selected task. It assumes a task view is the active view and the active cell is in a task row.

Visual Basic for Applications 
  Sub ResourceNames()

Dim A As Assignment

For Each A In <strong class="bterm">ActiveCell</strong>.Task.Assignments
    MsgBox A.ResourceName
Next A



End Sub

See Also