Application.Selection Property (Excel)

Office 2013 and later

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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

expression .Selection

expression A variable that represents an Application object.

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.

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


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

MsgBox "The selection object type is " & TypeName(Selection)