Share via


Window.RangeSelection Property

Excel Developer Reference

Returns a Range object that represents the selected cells on the worksheet in the specified window even if a graphic object is active or selected on the worksheet. Read-only.

Syntax

expression.RangeSelection

expression   A variable that represents a Window object.

Remarks

When a graphic object is selected on a worksheet, the Selection property returns the graphic object instead of a Range object; the RangeSelection property returns the range of cells that was selected before the graphic object was selected.

This property and the Selection property return identical values when a range (not a graphic object) is selected on the worksheet.

If the active sheet in the specified window isn’t a worksheet, this property fails.

Example

This example displays the address of the selected cells on the worksheet in the active window.

Visual Basic for Applications
  MsgBox ActiveWindow.RangeSelection.Address

See Also