Subtract two Columns(A-B) result in ColumnC (using Scripting.Dictionary)

[marreco]

hi.

I try learning about Scripting.Dictionary.
My question is:
How subtract two Columns(A-B) result in ColumnC (using Scripting.Dictionary).

Col A	Col B	Col C
29,06	38,05	-8,99
19,09	25,00	-5,91
29,00	37,17	-8,17
29,74	38,12	-8,38
29,00	37,17	-8,17
25,76	34,24	-8,48
38,43	51,09	-12,66
38,44	51,09	-12,66
39,55	52,57	-13,02
21,58	28,68	-7,10
22,52	29,93	-7,41
114,62	148,01	-33,39

<colgroup><col style="mso-width-source:userset;mso-width-alt:2194;width:45pt" width="60"> <col style="mso-width-source:userset;mso-width-alt:2230;width:46pt" width="61"> <col style="mso-width-source:userset;mso-width-alt:1865;width:38pt" width="51"> </colgroup><tbody>
</tbody>

 

[Fluff]

You wouldn't use a dictionary for something like that.
If you want to subtract one value from another with VBA, try

Sub marreco()
   With Range("C2", Range("B" & Rows.Count).End(xlUp).Offset(, 1))
      .Value = Evaluate("if({1}," & .Offset(, -2).Address & "-" & .Offset(, -1).Address & ","""")")
   End With
End Sub

 

[marreco]

Hi good, this solved my post
Thank you!!!

 

[Fluff]

You're welcome & thanks for the feedback