Excel 365: Cannot paste values to visible cells only
Solution 1:
The cell ranges are not the same. Some of the cells filtered out are still there, so Excel can't paste. Can you apply the formula to all the cells in the range, then hide the ones you don't want to see?