|
Sub 复制()
Application.DisplayAlerts = False
Dim sht As Worksheet, bm As String, i As Long
i = [A65536].End(xlUp).Row
x:
bm = InputBox("请输入新工作表名:", "新建工作表")
For Each sht In Worksheets
If sht.Name = bm Then MsgBox "工作表已存在,请重新输入名称": GoTo x
Next
Set sht = Sheets.Add
sht.Name = bm
Sheet7.Range("A1").Resize(i, 8).Copy
With Sheets(bm).Range("A1")
.PasteSpecial Paste:=xlPasteValues
.PasteSpecial Paste:=xlPasteFormats
.PasteSpecial Paste:=xlPasteColumnWidths
.Range("A1").Activate
End With
Application.CutCopyMode = False
End Sub
不知道你可以用不,这个是我现在用的哈!!! |
|