Filling a column or row with dates that increment by one day is very easy. Select the cell with the formula and the adjacent cells you want to fill. D LastPopulatedRowFillDown End Sub In the image below we can see that we had formula in cell D2 only and cell D3 to D10 were empty.
Sub CoopyFormulaDown Dim LastPopulatedRow As Long Find last populated row LastPopulatedRow RangeA RowsCountEndxlUpRow Select the rows where formula is to be populated RangeD2.
Sub FillDownFormula Filldown a formula for in column of data. Power Query will fill down each section of blank cells in the column with the value from the cell above it. Sub FillDownFormula Filldown a formula for in column of data. Dim rng As Range Dim rngData As Range.