Sub wayy() Dim i, l, h As Integer Dim arr1, arr2 l = [iv1].End(xlToLeft).Column arr1 = Range([a1], Cells(3, l)).Value ReDim arr2(1 To 2, 1 To l) h = 1 For i = 1 To l If arr1(1, i) = "3" Then arr2(1, h) = arr1(2, i) arr2(2, h) = arr1(3, i) h = h + 1 End If Next Sheet2.[a1].Resize(2, h) = arr2 MsgBox "数据分类完毕!!", , "wayy提示" End Sub
Sub wayy() Dim i, l, h As Integer Dim arr1, arr2 l = [iv1].End(xlToLeft).Column arr1 = Range([a1], Cells(3, l)).Value ReDim arr2(1 To 2, 1 To l) h = 1 For i = 1 To l If arr1(1, i) = "3" Then arr2(1, h) = arr1(2, i) arr2(2, h) = arr1(3, i) h = h + 1 End If Next Sheet2.[a1].Resize(2, h) = arr2 MsgBox "数据分类完毕!!", , "wayy提示" End Sub