|
本帖最后由 laoau138 于 2017-5-3 16:56 编辑
VBA数组倒数多少行开始计算 1-33这些数字次数
本帖最后由 france723 于 2017-5-3 16:26 编辑
- Sub aaa()
- Dim k, ar, br, n, v, t, h
- h = Range("a65536").End(3).Row
- If h > 189 Then
- MsgBox ("More than 189")
- Else
- k = 189 - [k1] + 1
- ar = Range("h189:c" & k)
- br = Range("k16:aq16")
- y = 11
- For Each n In br
- t = 0
- For Each v In ar
- If n = v Then
- t = t + 1
- End If
- Next v
- Cells(17, y) = t
- y = y + 1
- Next n
- End If
- End Sub
复制代码
|
|