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...g_vba_s_1.html

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

"Franco22 " wrote in message
...
Does anyone know where to find a list of the properties and methods of
the Selection object? I have found it to be very useful in writing VBA
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 currently
selected range.

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


---
Message posted from http://www.ExcelForum.com/