RangeSelection Property

Applies To

Window Object.

Description

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. This property is available only in Microsoft Excel for Windows 95. Read-only.

Remarks

When a graphic object is selected on a worksheet, the Selection property returns the graphic object instead of a Range; 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 a worksheet is not the active sheet in the specified window, this property fails.

Example

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


MsgBox ActiveWindow.RangeSelection.Address