Assigning Range In Bulk
There is an Excel file that teaches how to perform the Assigning Range In Bulk operation.
Excel Powered Assigning Range in Bulk
This workbook demonstrates assigning range in bulk using VBA macros on a 16-row data layout.
Hope it is useful.