|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
- Sub Demo()
- Dim i As Long, j As Long
- Dim arrData, rngData As Range
- Dim arrRes
- Dim iR(3) As Long
- Dim LastRow As Long, arr1, arr2, arr3
- LastRow = Cells(Rows.Count, "y").End(xlUp).Row
- If LastRow > 3 Then
- ReDim arr1(1 To LastRow - 2, 1 To 3)
- ReDim arr2(1 To LastRow - 2, 1 To 3)
- ReDim arr3(1 To LastRow - 2, 1 To 3)
- Set rngData = Range("Y2:aa" & LastRow)
- arrData = rngData.Value
- For i = LBound(arrData) To UBound(arrData)
- Select Case arrData(i, 1)
- Case Is = "¸ÄÖÆÖ°¹¤"
- iR(1) = iR(1) + 1
- For j = 1 To 3
- arr1(iR(1), j) = arrData(i, j)
- Next
- Case Is = "ºÏͬ¹¤"
- iR(2) = iR(2) + 1
- For j = 1 To 3
- arr2(iR(2), j) = arrData(i, j)
- Next
- Case Is = "ƸÓù¤"
- iR(3) = iR(3) + 1
- For j = 1 To 3
- arr3(iR(3), j) = arrData(i, j)
- Next
- End Select
- Next i
- End If
- Range("AG3:Ao" & Rows.Count).ClearContents
- If iR(1) > 0 Then _
- Range("AG3").Resize(iR(1), 3).Value = arr1
- If iR(2) > 0 Then _
- Range("aj3").Resize(iR(2), 3).Value = arr2
- If iR(3) > 0 Then _
- Range("am3").Resize(iR(3), 3).Value = arr3
- End Sub
复制代码 |
评分
-
1
查看全部评分
-
|