Selection object in Excel 2002

[Franco22]

Does anyone know where to find a list of the properties and methods o
the Selection object? I have found it to be very useful in writing VB
macros but it has no intellisense, so I have to do a lot of guesswork
Some code that I've used so far:

Selection.Clear 'this clears the currently selected range

Selection.Name="Whatever" 'this gives a range name to the currentl
selected range.

I'm sure there are lots more methods and properties and I just woul
like to see that list

 

[Frank Kabel]

Hi
Selection is a range object. So have a look at the range
methods/properties

 

[Dick Kusleika]

Franco

Selection is a property that refers to whatever object is selected and it
takes on that objects properties and methods. If a range is selected, you
use the properties and methods of a Range object. If a shape is selected,
you use the properties and methods of a Shape object.

See also

http://www.dicks-blog.com/excel/2004/04/beginning_vba_s_1.html