Hey, I've read other people's "Else Without If" debugging, but can't figure out my error message. I would love, love some help.
This is my vba code tagged alongside Excel 2003
If Eval > MD Then Days = 0
ElseIf Progress1 > MD Then Progress1 = ProgressScore And Progress1Day = ProgressDays And ProgressScore = Progress1 - MD And ProgressDays = Progress1Day
ElseIf Progress2 > MD Then Progress2 = ProgressScore And Progress2Day = ProgressDays And ProgressScore = Progress2 - MD And ProgressDays = Progress2Day - Progress1Day
ElseIf Progress3 > MD Then Progress3 = ProgressScore And Progress3Day = ProgressDays And ProgressScore = Progress3 - MD And ProgressDays = Progress3Day - Progress2Day
Else: Days = 0
End If
Thanks, peeps
This is my vba code tagged alongside Excel 2003
If Eval > MD Then Days = 0
ElseIf Progress1 > MD Then Progress1 = ProgressScore And Progress1Day = ProgressDays And ProgressScore = Progress1 - MD And ProgressDays = Progress1Day
ElseIf Progress2 > MD Then Progress2 = ProgressScore And Progress2Day = ProgressDays And ProgressScore = Progress2 - MD And ProgressDays = Progress2Day - Progress1Day
ElseIf Progress3 > MD Then Progress3 = ProgressScore And Progress3Day = ProgressDays And ProgressScore = Progress3 - MD And ProgressDays = Progress3Day - Progress2Day
Else: Days = 0
End If
Thanks, peeps