|
发表于 2016-8-20 23:44
|
显示全部楼层
本楼为最佳答案
- Sub test()
- Dim arr, brr()
- arr = Range(Cells(2, 2), Cells(2, 2).End(4))
- ReDim brr(1 To UBound(arr))
- For i = 1 To UBound(arr)
- Select Case arr(i, 1)
- Case Is < 50
- brr(i) = "D"
- Case Is < 100
- brr(i) = "C"
- Case Is < 500
- brr(i) = "B"
- Case Is < 1000
- brr(i) = "H"
- Case Else
- brr(i) = "TH"
- End Select
- Next
- [C2].Resize(UBound(arr), 1) = Application.Transpose(brr)
- End Sub
复制代码 |
评分
-
查看全部评分
|