Export (0) Print
Expand All
Expand Minimize

Application.Selection Property

Office 2007
Returns the selected object in the active window for an Application object.

Syntax

expression.Selection

expression   A variable that represents an Application object.

Remarks

The returned object type depends on the current selection (for example, if a cell is selected, this property returns a Range object). The Selection property returns Nothing if nothing is selected.

Using this property with no object qualifier is equivalent to using Application.Selection.

Example

This example clears the selection on Sheet1 (assuming that the selection is a range of cells).

Visual Basic for Applications
Worksheets("Sheet1").Activate
Selection.Clear

This example displays the Visual Basic object type of the selection.

Visual Basic for Applications
Worksheets("Sheet1").Activate
MsgBox "The selection object type is " & TypeName(Selection)



Community Additions

ADD
Show:
© 2015 Microsoft