|
本帖最后由 today0427 于 2016-9-22 20:08 编辑
改了一下,你看看对不对,和你的函数结果对不上,但是我查看了一下,我的结果好像没错,你自己再看看吧。
- Sub asdf()
- Dim w, maxr, prv, rs, nr, nc, redtmp
- w = Range("L8")
- Dim redn(33) As Integer
- maxr = Range("A65536").End(xlUp).Row
- Debug.Print maxr
- prv = CInt(Range("p8"))
- rs = maxr - prv
- For nr = 10 To rs
- If Range("J" & nr) = w Then
- For nc = 1 To 6
- redtmp = CInt(Range(Chr(66 + nc) & nr)) 'Chr66代表B
- redn(redtmp) = redn(redtmp) + 1
- Next
- End If
- Next
-
- For i = 0 To 32
- Range("N" & 11 + i) = redn(i + 1)
- Next
- End Sub
复制代码 |
评分
-
查看全部评分
|