Selection object in Excel 2002
 

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

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

Selection object in Excel 2002
 

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Franco22 " schrieb im
Newsbeitrag ...
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/

Selection object in Excel 2002
 

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/