Maybe since Range is an atypical object (both an
object and a collection)
Just for fun and to add to the confusion.
You have a Workbook, and a Workbooks Collection, a Sheet, and a Sheets
collection. There is also a Row, and a Rows collection. There are many
more like Chart, and the Charts collection...etc. A collection is anything
with an 's at the end. (vbg).
You have Range, but no Ranges collection, so it fails the 's test. For
this, one needs "Areas" Now, that has an 's at the end, so Areas is a
collection. It's so confusing. :)
--
Dana DeLouis
Using Windows XP & Office XP
= = = = = = = = = = = = = = = = =
"Dick Kusleika" wrote in message
...
Had a hard time finding this...
Default Property/Methods for Objects in Visual Basic
http://support.microsoft.com/default...57&Product=xlw
Hmmm. Now I'm confused. Maybe since Range is an atypical object (both an
object and a collection) the Value and Item are both default properties
(the
help you quoted notwithstanding). And the existence of arguments
determines
which one is used.
But then the Item property for Range doesn't work like other Item
properties. You can't get a subscript error with Range.Item like most
(all?) other collections. It's probably just incorrect of me to think of
Range as a collection.
--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com