Window.Selection property (Excel)

Returns the specified window, for a Windows object.

Syntax

expression.Selection

expression A variable that represents a Window 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)

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.