Selection Property
Applies To
Application object, Window object.
Description
Application object: Returns the selected object in the active window.
Window object: Returns the selected object in the specified window.
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.
See Also
Activate method, ActiveCell property, Select method.
Example
This example clears the selection on Sheet1 (assuming that the selection is a range of cells).
Worksheets("Sheet1").Activate
Selection.Clear
This example displays the Visual Basic object type of the selection.
Worksheets("Sheet1").Activate
MsgBox "The selection object type is " & TypeName(Selection)