I am working with VBA in Excel. I have added a command button. I would like to copy a row/column A8 through F8 (formulas) and then fill (paste?) these formulas down based on a number entered in Cell B1. I have found many techniques for Macro Sheets (that do not work in VBA), but nothing that applied to VBA.
I would appreciate any assistance and/or explanation.