Default property of Range object

[tiredofit]

It is common to omit the default property in VBA and code will still work.

For example:

Cells(1,1) = 10

and

Cells(1, 1).Value = 10

both work equally well.

Is it true that the Range property DOES NOT have a default property?

I have seen:

Range("A1") = 20

and

Range("A1").Value = 20

ie the default property here for the Range object is Value.

but also:

Dim Rng As Range
Set Rng = Range("A1:D4")

Dim abc As Range

For Each abc In Rng

    abc.Value= 30

Next abc

and

Dim Rng As Range
Set Rng = Range("A1:D4")

Dim abc As Range

For Each abc In Rng.Cells

    abc.Value= 30

Next abc

the default property for Range is Cells?

Thanks

 

[Fluff]

The default property of Range is Value, but with your loop you are specifying for each range in range which is different.

 

[tiredofit]

Thanks for clarifying.

 

[Fluff]

You're welcome