SELECTION function

[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.

 

[Frank Kabel]

Hi
simply use something like
msgbox selection.address

 

[Ahasuerus]

But where do I find THAT? Noty in the 'help' files.

 

[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

 

[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

 

[AlfD]

Hi!

My guess is you were using the Excel Help file, not the VBE (VBA) Hel
file.

Al