- ©«¤l
- 262
- ¥DÃD
- 8
- ºëµØ
- 0
- ¿n¤À
- 280
- ÂI¦W
- 16
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- Office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- HK
- µù¥U®É¶¡
- 2015-8-11
- ³Ì«áµn¿ý
- 2024-3-28
|
- Sub zz()
- Application.ScreenUpdating = 0
- Dim rng As Range, d As Object, ws As Worksheet
- Set ws = ActiveSheet
- ws.AutoFilterMode = False
- c = [a3].CurrentRegion.Columns.Count
- Set d = CreateObject("scripting.dictionary")
- Set rng = Range([a5], Cells(Cells(Rows.Count, 1).End(3).Row, c))
- a = rng.Columns(3)
- For i = 2 To UBound(a)
- d(a(i, 1)) = ""
- Next
- k = d.keys
- For i = 0 To UBound(k)
- ws.Copy after:=Sheets(Sheets.Count)
- ActiveSheet.AutoFilterMode = False
- [a3].CurrentRegion.Clear
- With ws
- rng.AutoFilter Field:=3, Criteria1:=k(i)
- .[a3].CurrentRegion.Copy [a3]
-
- End With
- ActiveSheet.Name = [c6].Value
- Next
- Application.ScreenUpdating = 1
- End Sub
½Æ»s¥N½X |
|