代码数组: Sub wayy() Dim mrow As Long Dim zrow As Long Dim arow As Long Dim arr1, arr2 arr1 = Range("A2", [B65536].End(xlUp)) ReDim arr2(1 To UBound(arr1), 1 To 2) For mrow = 1 To UBound(arr2) If arr1(mrow, 1) = "A" Then arow = arow + 1 arr2(arow, 1) = arr1(mrow, 1) arr2(arow, 2) = arr1(mrow, 2) End If Next [D2:E65536].ClearContents [D2].Resize(arow, 2) = arr2 End Sub
[此贴子已经被作者于2009-11-20 16:36:38编辑过] |