VBA is not required, enter Dadylonglegs formula in the first cell, then doubleclick on the fill handle to get the formula down to the last cell.,

If you want this done in VBA, then attach a sample workbook