Application.Selection (Excel)

Returns the currently selected object on the active worksheet for an Application object. Returns Nothing if no objects are selected. Use the Select method to set the selection, and use the TypeName function to discover the kind of object that is selected.

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.


Dim objSelection As Object
Set objSelection = Selection