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