Creating Range One By One
There is an Excel file that teaches how to perform the Creating Range One By One operation.
Excel Creating Range One By One
This workbook demonstrates creating range one by one using VBA macros on a 2-row data layout.
Hope it is useful.