Quote Originally Posted by MagPower View Post
Paul,

Just curious, what is the difference between the following two statements?

Set r1 = ws1.Cells(1, 1).End(xlDown).CurrentRegion
and
Set r1 = ws1.Cells(1, 1).CurrentRegion

Has to do with where the block of data (.CurrentRegion) starts

If it's A3:Z26 vs. A1:26