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:
Here is the output:Please Login or Register to view this content.
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
Bookmarks