wnazzaro
06-29-2005, 09:09 AM
Hello again. Let's start with my code that is giving me problems.
'A
dd new numbers for RecruitMeetLoad.
If Month(LPFVDate) = 1 Or 4 Then
RecruitMeetLoad = TxLoad
ElseIf Month(LPFVDate) = 7 Or 10 Then
RecruitMeetLoad = TxLoad
ElseIf Month(LPFVDate) = 2 Or 5 Then
RecruitMeetLoad = (RecruitLoad + TxLoad) / 2
ElseIf Month(LPFVDate) = 8 Or 11 Then
RecruitMeetLoad = (RecruitLoad + TxLoad) / 2
Else
RecruitMeetLoad = RecruitLoad
End If
Cells(Target.row, LPFVCol) = RecruitMeetLoad
When I watch this in Break mode it goes from the first line to the second to End If which would be fine except Month(LPFVDate) = 2. This should go from the first line to the fifth or sixth, not the second.:dunno
'A
dd new numbers for RecruitMeetLoad.
If Month(LPFVDate) = 1 Or 4 Then
RecruitMeetLoad = TxLoad
ElseIf Month(LPFVDate) = 7 Or 10 Then
RecruitMeetLoad = TxLoad
ElseIf Month(LPFVDate) = 2 Or 5 Then
RecruitMeetLoad = (RecruitLoad + TxLoad) / 2
ElseIf Month(LPFVDate) = 8 Or 11 Then
RecruitMeetLoad = (RecruitLoad + TxLoad) / 2
Else
RecruitMeetLoad = RecruitLoad
End If
Cells(Target.row, LPFVCol) = RecruitMeetLoad
When I watch this in Break mode it goes from the first line to the second to End If which would be fine except Month(LPFVDate) = 2. This should go from the first line to the fifth or sixth, not the second.:dunno