Applying Loops on Large Data
There is an Excel file that teaches how to perform the Applying Loops on Large Data operation.
Excel Spreadsheet for Applying Loops On Large Data
This workbook runs VBA loops over 1000 rows of data, demonstrating performance characteristics of macro-based iteration on large datasets.
Hope it is useful.