Subtract Values in Two Ranges VBA

[elmnas]

I am trying to write VBA code to subtract column A from column B. I want it to take the first cell in each range and do the math then output the resulting value in column C.
i.e. the output should look like:

Could someone help me?

Thank you

 

[JoeMo]

Sub TheDifference()
With Range("A1", Cells(Rows.Count, 1).End(xlUp).Address(0, 0))
    With .Offset(0, 2)
        .Formula = "=SUM(-A1,B1)"
        .Value = .Value
    End With
End With
    
End Sub

 

[elmnas]

Sub TheDifference()
With Range("A1", Cells(Rows.Count, 1).End(xlUp).Address(0, 0))
    With .Offset(0, 2)
        .Formula = "=SUM(-A1,B1)"
        .Value = .Value
    End With
End With
    
End Sub

Thank you