Ranges with same address behaving differently with offset

I can probably work around this, but I don't understand why it is happening.
The attached spreadsheet has everything set up. Here is the code:

Please Login or Register  to view this content.

Here is the output:
badr address is: $D$1:$F$7
goodr address is: $D$1:$F$7
badr(2) address is: $E$1:$E$7
goodr(2) address is: $E$1

I don't understand how these two ranges can have the same address, yet behave differently when using the (2) offset. I thought it always went by cell (and that is what my other code was expecting).

Thanks

Well, the solution is to use
badr.cells(2).address
But, I'm still curious what is going on internally to yield the different results (and if there is a way to test for it).

Thanks.

@dangelor
Interesting. I thought using comma delimiters allowed me to assign many variables on one line.
From: https://docs.microsoft.com/en-us/dot.../dim-statement
Declaring Multiple Variables
You can declare several variables in one declaration statement, specifying the variable name for each one, and following each array name with parentheses. Multiple variables are separated by commas.

Please Login or Register  to view this content.

However, putting them as separate Dim xxxx as Range lines of code made them act similarly (goodr now matches badr), so at least now there is some consistency.

I agree with @dangelor.

goodr is a variant type. While a range can be treated as an array like you are doing (never seen anyone do this, I always use range.offset) the variant likely cannot. So the range type "offsets" the whole range were as the variant may only offset the first cell of the range.

Please Login or Register  to view this content.

Try the above and see if it works as you had posted it. Other wise use the methods of the range object to accomplish this (.offset, .resize, etc)

You can declare multiple variables on a single line, but just like declaring them 1 per line, if you dont give them a type they default to variant.

Also, the link you gave is for Visual Basic, not VBA...they are very different.

Pulled from the article:

You can declare several variables in one statement. To specify a data type, you must include the data type for each variable. In the following statement, the variables intX, intY, and intZ are declared as type Integer.

Please Login or Register  to view this content.

In the following statement, intX and intY are declared as type Variant, and only intZ is declared as type Integer.

Please Login or Register  to view this content.

No worries we have all done it at one point or another.