Sub DealerStick3()
dealer = Range("F22").Value
setdef = 17
If dealer < setdef Then
stick3
Else
ActiveCell.FormulaR1C1 = "=SUM(R[-5]C:R[-1]C)"
End
End If
End Sub
Sub stick3()
dealer = Range("F22").Value
setdef = 17
dealer3:
Calculate
flagcell = Range("H4").Value
If Range(flagcell).Value = 1 Then
GoTo dealer3:
End If
Range("C3:F3").Select
Selection.Copy
Range(flagcell).Value = 1
Range("C19").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
Range("F22").Select
dealer = Range("F22").Value
DealerStick4
ActiveCell.FormulaR1C1 = "=SUM(R[-5]C:R[-1]C)"
End Sub
Sub DealerStick4()
dealer = Range("F22").Value
setdef = 17
If dealer < setdef Then
stick4
Else
ActiveCell.FormulaR1C1 = "=SUM(R[-5]C:R[-1]C)"
End
End If
End Sub
Sub stick4()
dealer = Range("F22").Value
setdef = 17
dealer4:
Calculate
flagcell = Range("H4").Value
If Range(flagcell).Value = 1 Then
GoTo dealer4:
End If
Range("C3:F3").Select
Selection.Copy
Range(flagcell).Value = 1
Range("C20").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
Range("F22").Select
dealer = Range("F22").Value
DealerStick5
ActiveCell.FormulaR1C1 = "=SUM(R[-5]C:R[-1]C)"
End Sub
Sub DealerStick5()
dealer5:
Calculate
flagcell = Range("H4").Value
If Range(flagcell).Value = 1 Then
GoTo dealer5:
End If
Range("C3:F3").Select
Selection.Copy
Range(flagcell).Value = 1
Range("C21").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
Range("F22").Select
ActiveCell.FormulaR1C1 = "=SUM(R[-5]C:R[-1]C)"
End
End Sub