Filling Formulas with Macro
There is an Excel file that teaches how to perform the Filling Formulas with Macro operation.
Excel-Based Filling Formulas with Macro
This workbook uses VBA to automatically insert formulas into designated cells across a 12-row worksheet layout with 8 formula entries.
Hope it is useful.