|
楼主 |
发表于 2018-7-18 19:18
|
显示全部楼层
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
Sub 新建工作表()
star1:
Dim gzb As Worksheet
Dim i As Integer
Sheets("隐藏模板").Visible = True
Sheets("隐藏模板").Copy BEFORE:=Sheet5
Set gzb = ActiveSheet
On Error GoTo 99
gzb.Name = Application.Text(Now, "M月")
gzb.Range("A3") = "日期: " & Application.Text(Now, "YYYY年M月")
Sheets("隐藏模板").Visible = 2
On Error GoTo 98
Sheets(Month(Now()) - 1 & "月").Range("F40:V40").Copy Sheets(Month(Now()) & "月").Range("F8")
MsgBox Application.Text(Now, "M月") & "创建完毕"
End
99
Application.DisplayAlerts = False
ActiveSheet.Delete
Application.DisplayAlerts = True
Sheets("隐藏模板").Visible = 2
y = MsgBox(Application.Text(Now, "M月") & "工作表已存在,是否删除重新创建工作表", 4)
If y = 6 Then
Application.DisplayAlerts = False
Sheets(Application.Text(Now, "M月")).Delete
Application.DisplayAlerts = True
GoTo star1
End If
98
MsgBox Sheets(Month(Now()) - 1 & "月") & "工作表不存在"
End Sub
大佬,我刚学VBA没几天,逻辑思维没有那么强,或许我写的太绕了。。
|
|