SELECTION function

A

Ahasuerus

What ever happened to the SELECTION function? It was
described as "Returns the reference or object identifier
of the selection as an external reference" I wish to use
it in a Macro to detect the area which the user has
selected.
 
F

Frank Kabel

Hi
not sure what Excel version you're using but my (German) VBA help
returns some example code for the selection object including a
cross-reference to the range object
 
G

Gord Dibben

In VBEditor mode. Excel 2002

Help>Answer Wizard "selection" returns several hits.

One of which is....................

RangeSelection Property

See Also Applies To Example Specifics
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.

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.

MsgBox ActiveWindow.RangeSelection.Address



Gord Dibben Excel MVP
 
Top