Excel VBA Help Gripe
I searched for Range and it returend a page with a number of items shwoing
teh Range property as it applies to different objects. This confirms that
range can be a property, and if you clicked the Application, Range,
Worksheet objects item, it explains the usage, quote ...
expression.Range(Cell1, Cell2)
expression Required. An expression that returns one of the above objects.
Cell1 Required Variant. The name of the range. This must be an A1-style
reference in the language of the macro. It can include the range operator (a
colon), the intersection operator (a space), or the union operator (a
comma). It can also include dollar signs, but they're ignored. You can use a
local defined name in any part of the range. If you use a name, the name is
assumed to be in the language of the macro.
Cell2 Optional Variant. The cell in the upper-left and lower-right corner
of the range. Can be a Range object that contains a single cell, an entire
column, or entire row, or it can be a string that names a single cell in the
language of the macro.
which tells you that range can also be an object.
That seems pretty good to me. The difficult is understanding OO and the
object model. Help seems to work quite well within that.
--
HTH
Bob Phillips
"keithb" wrote in message
...
Am I the only one having difficulty using Excel VBA help? It would be ever
so much more useful if documentation for objects, properties, events and
methods were returned in the search listings. As a new user, I did not
know
whether a Range is an Object, Property, or Collection, so I searched for
"Range" which did not return anything useful. As a result I wasted a long
time before finding Range under Collections.
Keith
|