|
发表于 2016-7-29 10:09
|
显示全部楼层
本楼为最佳答案
- Sub Macro1()
- On Error Resume Next
- Set sht = Sheets("数据源")
- arr = sht.Range("a1").CurrentRegion
- n = UBound(arr, 2)
- Application.DisplayAlerts = False
- For Each sh In Sheets
- If sh.Name <> "数据源" Then sh.Delete
- Next
- Application.DisplayAlerts = True
- For i = 2 To UBound(arr)
- If Not Sheets(arr(i, 1)) Is Nothing Then
- With Sheets.Add(after:=Sheets(Sheets.Count))
- sht.[a1].Resize(1, n).Copy .[a1]
- sht.Cells(i, 1).Resize(1, n).Copy .[a2]
- .Name = arr(i, 1)
- End With
- End If
- Next
- sht.Activate
- End Sub
复制代码 |
|