Under Editing Options check the Enable fill handle and cell drag-and-drop box. Expand the Table with AutoExpansion. Type a number into a cell in an Excel spreadsheet.
Sub CoopyFormulaDown Dim LastPopulatedRow As Long Find last populated row LastPopulatedRow Range A RowsCountEnd xlUpRow Select the rows where formula is to be populated Range D2.
When she would click a formula cell and drag down to calculate it across multiple rows it only copied the value. Youll know you have hit it when the cursor changes to a plus sign. Sub CoopyFormulaDown Dim LastPopulatedRow As Long Find last populated row LastPopulatedRow Range A RowsCountEnd xlUpRow Select the rows where formula is to be populated Range D2. If you want the cells below F2 that is starting in F3 and down to the row above the last row based on column D to be incremented by 1 starting with whatever number you have in cell F2 this code line would do that.