Hello. This formula copies rows with constants into a section to the right and then goes to the next line after each copy. For the last line, why do they use rng.rows.count as opposed to just offset one row. It seems like offsetting rows.count would increase the space between rows as the input gets bigger...1,2,3,4, etc. 

Sub CopyAreas()
Set NewDestination = ActiveSheet.Range("I1")
    For Each Rng In Cells.SpecialCells(xlCellTypeConstants, 1).Areas
        Rng.Copy Destination:=NewDestination
        Set NewDestination = NewDestination.Offset(Rng.Rows.Count)
    Next Rng

End Sub