以下是引用sunsoso在2010-1-23 12:52:00的发言: 那么如何 用VBA实现 。请教 程序代码。谢谢 Sub 分类存放() Dim arr, arr1, arr2() Dim myrow myrow = Sheets("sheet1").Range("h65536").End(xlUp).Row - 1 arr = Sheets("sheet1").Range("a2:h" & myrow + 1) Set d = CreateObject("Scripting.Dictionary") '取得唯一的分类 For x = 1 To myrow d(arr(x, 8)) = arr(x, 8) Next x arr1 = d.keys For y = 0 To UBound(arr1) ReDim arr2(1 To myrow, 1 To 8) For x = 1 To myrow If arr(x, 8) = arr1(y) Then k = k + 1 For j = 1 To 8 arr2(k, j) = arr(x, j) Next j End If Next x Set mysheet = Sheets.Add mysheet.Name = arr1(y) mysheet.Range("a1:h1").Value = Sheets("sheet1").Range("a1:h1").Value mysheet.Range("a2").Resize(k, 8) = arr2 Erase arr2 k = 0 Next y End Sub
0ll3tufp.rar
(9.15 KB, 下载次数: 114)
|