1
2
3
4
Sub Main()
    Range("B1") = "=IF(ISBLANK(A2),"""",A2-A1)"
    Range("B1").Resize(Range("A1").End(xlDown).Row).FillDown
End Sub