EXCEL 初学VBA, 编个小程序;

2025-03-17 14:04:23
推荐回答(1个)
回答1:

我也是初学者,相互学习
Sub test()
Dim i%, j%, col%
j = 0
col = 2
For i = 1 To 3
If Cells(2, col).Value >= 90 Then
j = j + 1
End If
col = col + 1
Next
If j >= 2 Then
Cells(2, 6) = 100
End If
End Sub