Returns the selected object in the active window, for an Application object, and a specified window, for a Windows 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).
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)