Help debug loop?

[VulcanJedi]

Can someone please help, I don't understand what is wrong with this code.... the inner loop doesn't execute at all, debugging by stepping through code goes from the inner For loop directly to the outer NEXT ?)

Nothing in in loop u runs at all?

For y = 0 To (numWks - 1)
For u = 1 To numJobs
If mainsht.Cells(8 + (6 * u), wkStart + 1 + y) = "" Then
'only baseline schedule
WkSum = WkSum + mainsht.Cells(7 + (6 * u), wkStart + 1 + y)
Else
WkSum = WkSum + mainsht.Cells(8 + (6 * u), wkStart + 1 + y)
End If

ActSum = ActSum + mainsht.Cells(9 + (6 * u), wkStart + 1 + y)
Next u
Next y

 

[kylua]

My first thought is that numjobs hasn't been given a value.

 

[VulcanJedi]

thanks kylua, actually I figured it out finally I didn't realize that the value wasn't correct, I negected to notice that the derivative of numJobs had changed slightly completely throwing things off. thx