Difficult to comment with certainty without seeing the request in the context of its workbook but avoid a loop and consider using Autofilter to first filter the rows you're trying to update and then add the relevant formulae to the filtered rows before removing the autofilter.