Do While |
Do CurrentG = Range("G" & GetLine).Value G_Cnt = G_Cnt + 1 GetLine = GetLine + 1 Loop While Range("G" & GetLine).Value = CurrentG |
---|---|
Do While GetLine <= Lmax Windows(A_name).Activate Sheets("純新規").Select 担当 = CurrentG Call データ書出(2, 担当, G_Cnt) G_Cnt = 0 Loop |
|
For Next |
For I = 2 To Lmax step +/-増分 Next I |
Case 値チェック |
Select Case 種類 Case "A", "B", "C" Case Else End Select |
Case 大小比較 |
Select Case 工事開始日 Case Is > WB期間開始 Case Is = WB期間開始 Case Else End Select |
Case 範囲比較 |
Select Case 値 Case 80 To 100 Case 70 To 79 Case 60 To 69 Case 0 To 59 Case Else MsgBox "エラー" End Select |