|
Option Explicit
Sub TEST2()
Dim ar, i&, wks As Worksheet
Application.ScreenUpdating = False
Application.DisplayAlerts = False
For Each wks In Worksheets
If wks.Name <> "表名" And wks.Name <> "模板" Then wks.Delete
Next
ar = Worksheets(1).[A1].CurrentRegion.Value
For i = 2 To UBound(ar)
Worksheets("模板").Copy after:=Worksheets(Worksheets.Count)
With ActiveSheet
.[B2].Value = ar(i, 1)
.Name = ar(i, 1)
End With
Next i
Application.DisplayAlerts = True
Application.ScreenUpdating = True
Beep
End Sub
|
评分
-
1
查看全部评分
-
|