Question: what is the difference between usedrange and currentregion properties?
Answer: Almost like a range's CurrentRegion property, but something that will ONLY return any filled cells WITHIN the range I have defined (whereas CurrentRegion every filled cell that is "touching" or adjacent to the Range, regardless if it within that range's bounds).