Refreshing Range Quickly
There is an Excel file that teaches how to perform the Refreshing Range Quickly operation.
Excel Template for Refreshing Range Quickly
This workbook demonstrates refreshing range quickly using VBA macros on a 9-row data layout.
Hope it is useful.