Cells Method using Ranges

Imagine each range as a mini worksheet with it's own rows and columns.

So when you have rngRows.Cells(1,2) the Cells(1,2) refers to a cell in the mini worksheet rngRows.

Similarly with rowRng and mapRng.Rows, rowRng is referring to rows in the mini worksheet mapRng.

PS For rngRow.Cells(1,2) you could actually use rngRow.Range("B1"), but that would just be confusing.

That is amazing! Thank you, thank you! That simple explanation made all the difference between me pretending to understand to actually understanding the code - and now I will be able to use it (not just muddle through it) in future macros!

Thank you, again!