帮我看看,代码错在哪里! Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$M$7" Then Sheets(Target.Value).Range("A:L").Copy Sheets("b").Range("A1") ElseIf Target.Address = "$J$2" Then Dim str As String Dim i As Integer Dim Sh As Worksheet Sheets("b").Columns(2).Clear str = [j2].Value For Each Sh In Worksheets If InStr(Sh.Name, str) Then i = i + 1 Sheets("b").Cells(i, 2) = Sh.Name End If Next End If Application.EnableEvents = True End Sub Private Sub Worksheet_Activate() Dim Dic As Object, Ary, k% Set Dic = CreateObject("Scripting.Dictionary") With Sheets("b") Ary = .Range("A4", .[A65536].End(3)) End With For k = 1 To UBound(Ary) Dic(Ary(k, 1)) = "" Next With Sheets("b") .[R:R].Clear .[R4].Resize(Dic.Count).Value = Application.Transpose(Dic.keys) .[R4].Resize(Dic.Count).Sort key1:=.[R4], order1:=1, Header:=xlNo End With Dic.RemoveAll End Sub
LS7NKwAx.rar
(13.1 KB, 下载次数: 0)
|