Guest User

Untitled

a guest
Oct 19th, 2018
99
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.90 KB | None | 0 0
  1. For i = 2 To CD_callendRow
  2. currentStation = Cells(i, CD_stationColumn).Value
  3.  
  4. If Cells(i, CD_uniqueduplicateColumn) = "Unique" Then
  5. If Cells(i, CD_durationcategoryColumn) = ">1" Then
  6. internalFile.Cells(stationDict(currentStation), WT_01Column).Value = internalFile.Cells(stationDict(currentStation), WT_01Column).Value + 1
  7. ElseIf Cells(i, CD_durationcategoryColumn) = ">30" Then
  8. internalFile.Cells(stationDict(currentStation), WT_01Column).Value = internalFile.Cells(stationDict(currentStation), WT_01Column).Value + 1
  9. internalFile.Cells(stationDict(currentStation), WT_30Column).Value = internalFile.Cells(stationDict(currentStation), WT_30Column).Value + 1
  10. ElseIf Cells(i, CD_durationcategoryColumn) = ">60" Then
  11. internalFile.Cells(stationDict(currentStation), WT_01Column).Value = internalFile.Cells(stationDict(currentStation), WT_01Column).Value + 1
  12. internalFile.Cells(stationDict(currentStation), WT_30Column).Value = internalFile.Cells(stationDict(currentStation), WT_30Column).Value + 1
  13. internalFile.Cells(stationDict(currentStation), WT_60Column).Value = internalFile.Cells(stationDict(currentStation), WT_60Column).Value + 1
  14. ElseIf Cells(i, CD_durationcategoryColumn) = ">600" Then
  15. internalFile.Cells(stationDict(currentStation), WT_01Column).Value = internalFile.Cells(stationDict(currentStation), WT_01Column).Value + 1
  16. internalFile.Cells(stationDict(currentStation), WT_30Column).Value = internalFile.Cells(stationDict(currentStation), WT_30Column).Value + 1
  17. internalFile.Cells(stationDict(currentStation), WT_60Column).Value = internalFile.Cells(stationDict(currentStation), WT_60Column).Value + 1
  18. internalFile.Cells(stationDict(currentStation), WT_600Column).Value = internalFile.Cells(stationDict(currentStation), WT_600Column).Value + 1
  19. End If
  20. End If
  21. Next
Add Comment
Please, Sign In to add comment