ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Range object evaluates to Range.value, or Range object (https://www.excelbanter.com/excel-programming/429671-range-object-evaluates-range-value-range-object.html)

[email protected]

Range object evaluates to Range.value, or Range object
 
In most equations, when a Range object shows up in an expression on
the right hand side of the assignment operator "=", the range object's
value is used. I'm interested in assigning a range object to a
variable that has been dim'd as type Range.

Where can one find the rules that govern what objects evaluate to when
they show up in expressions?

Also, in many cases, things like Range are used in the documentation
to describe a Range object as well as a collection of range objects.
Where in the documentation does it describe how the word Range is
interpretted in (say) a Dim statement? What about rules governing
whether a collection is returned in evaluating an expression, or
whether a default object within the collection is returned?

Thanks. (I'm using Office 2003)



All times are GMT +1. The time now is 01:21 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com