I am just learning VBA for excel. I have a formula that I am having repeat numerous times. In this formula I am subtracting 2 cells. How do I preserve the formula while allowing it to change to the next row? If you look below, I am asking how to change "b5-C5" to "b6-C6" and so on as the code repeats.
Selection.Offset(0, 2).Formula = "=B5-C5"
Thanks!
Selection.Offset(0, 2).Formula = "=B5-C5"
Thanks!