.Value property on Range() in VBA

Question

Some Excel VBA code I've seen does not used the .Value property on the Range object, for example:

myX = Range("A1")

rather than

myX = Range("A1").Value

Is this just because the default behavior of the range object is to return the value in the cell? Is there ever a time when I would not want to use this property to access the numerical value in a cell?

chris neilsen · Accepted Answer · 2014-08-31 06:55:48Z

3

Value is the default property of Range. So any code that expects a property and refers to a Range alone, will get Value.

There are other properties that will return a range's "value" such as Value2, Text, and sometimes Formula* which have their specific uses.

answered Aug 31, 2014 at 6:55

chris neilsen

53.3k10 gold badges91 silver badges127 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Kapé Over a year ago

When are the Value2, Text, and Formula properties returned as default value? I looked at the documentation of Range but no mention at all about default properties. Or is this standard VBA behaviour?

chris neilsen Over a year ago

They are Never returned as default.

Kapé Over a year ago

So I misunderstood ;-) I'm still wondering if it's not documented that Value is implicitly returned...

Collectives™ on Stack Overflow

.Value property on Range() in VBA

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related