Hi, I've been trying to repeat the calculations for a range using excel VBA
Here is the formula
If Range("H9") = "Repair" Then
Range("K9") = Range ("K9") + Range("G9")
If Range("H9") = "Service" Then
Range("L9") = Range ("L9") + Range("G9")
End If
Can someone please shed some lights on how to repeat this for a range, says 9 to 20?
Thanks a lots
Regards,
Steve
Here is the formula
If Range("H9") = "Repair" Then
Range("K9") = Range ("K9") + Range("G9")
If Range("H9") = "Service" Then
Range("L9") = Range ("L9") + Range("G9")
End If
Can someone please shed some lights on how to repeat this for a range, says 9 to 20?
Thanks a lots
Regards,
Steve