VBA第6课 循环判断数据

Sub do_loop循环判断()
Dim cj%
cj = 1
Do
cj = cj + 1
    If cj > 10 Then
        Exit Do               '退出循环
    Else
        If Cells(cj, 2) >= 90 Then Cells(cj, 3) = "优秀"
        If Cells(cj, 2) >= 80 And Cells(cj, 2) <= 90 Then Cells(cj, 3) = "良好"
        If Cells(cj, 2) >= 60 And Cells(cj, 2) <= 80 Then Cells(cj, 3) = "合格"
        If Cells(cj, 2) < 60 Then Cells(cj, 3) = "不及格"
        End If
Loop
End Sub

-----------------------------------------------------------------------------------

下面较常用:

在下标有规律且单元格区域相邻的情况下:

Sub 循环()
Dim n As Integer
For n = 1 To 8