|
发表于 2014-8-14 11:58
|
显示全部楼层
本楼为最佳答案
- Sub t()
- Dim arr, brr, re#(), i&, j%, irow&
- On Error Resume Next
- arr = Range(Range("A2").Value & ":" & Range("A3").Value).Value
- If Err.Number Then MsgBox "输入的单元格范围错误,请重新输入": Exit Sub
- brr = Range("D2").Resize(2, UBound(arr, 2)).Value
- ReDim re(1 To UBound(arr), 1 To 1)
- For j = 1 To UBound(arr, 2)
- For i = 1 To UBound(arr)
- If arr(i, j) >= brr(1, j) And arr(i, j) <= brr(2, j) Then re(i, 1) = re(i, 1) + 1
- Next
- Next
- irow = Cells(Rows.Count, 3).End(xlUp).Row
- If irow > 4 Then Range("C5:C" & irow).ClearContents
- Range("C5").Resize(UBound(re)) = re
- End Sub
复制代码 |
评分
-
查看全部评分
|