Range values

[tiredofit]

Assume I have the value of 1 in cell A1, 2 in B1, 3 in C1, 4 in A2, 5 in B2 and 6 in C2.

This is my code:

Dim Rng As Range


Set Rng = Range("A1:C1")

If I type:

Debug.Print Rng(1)

I get a value of 3, as expected.


However, why is it when I type:

Debug.Print Rng(4)

I get a value of 4.


I expected it to error because Rng is set to be the range A1 to C1 only.


Thanks

 

[footoo]

Rng(4) is the same as Rng.Item(1,4) - See link below

Basically, it operates in the same way as Offset, so it can reference cells outside of the range.

https://docs.microsoft.com/en-us/office/vba/api/excel.range.item

 

[Akuini]

I think Rng(4) is not the same as Rng.Item(1,4), it's the same as Rng.Item(4).
rng(3) is C1 then it will go down to A2, so rng(4) is A2 not D1.

 

[footoo]

I think Rng(4) is not the same as Rng.Item(1,4), it's the same as Rng.Item(4).
rng(3) is C1 then it will go down to A2, so rng(4) is A2 not D1.

You are right.