Sub SmlCount()
Dim i As Integer
Dim j As Integer
Dim k As Integer
Dim l As Integer
Dim count0 As Variant
Dim count25 As Variant
Dim count50 As Variant
Dim count75 As Variant
Dim count100 As Variant
For i = 1 To 100
For j = 1 To 100
For k = 1 To 100
If Workbooks("波动性_02").Cells(1, i) = "境内货币市场类" Then ’从这行开始下标越界,麻烦给位达人帮忙解决一下,谢谢~
If Workbooks("波动性_02").Range("C" & j) = "1" Then
If Workbooks("波动性_02").Range("K" & k) = 0 Then
count0 = count0 + 1
Else
If Workbooks("波动性_02").Range("K" & k) = 25 Then
count25 = count25 + 1
Else
If Workbooks("波动性_02").Range("K" & k) = 50 Then
count50 = count50 + 1
Else
If Workbooks("波动性_02").Range("K" & k) = 75 Then
count75 = count75 + 1
Else
If Workbooks("波动性_02").Range("K" & k) = 100 Then
count100 = count100 + 1
End If
End If
End If
End If
End If
End If
End If
Next k
Next j
Next i