Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Range object evaluates to Range.value, or Range object | Excel Programming | |||
Assigning AutoFiltered Range to Range Object | Excel Programming | |||
drop first row in range and return a new range object | Excel Programming | |||
Excel Addin:Setting the range to the Excel.Range object range prop | Excel Worksheet Functions | |||
Range Question / error 1004: method Range of object Worksheet has failed | Excel Programming |