|
回复 plues 的帖子
- Sub test()
- Dim sh As Worksheet
- Dim i As Integer, j As Integer, r As Integer
- Dim arr(1 To 12) As Integer
-
- '防出错
- If Sheets.Count > 1 Then
- Application.DisplayAlerts = False
- For Each sh In Sheets
- If sh.Name <> "模板" Then
- sh.Delete
- End If
- Next sh
- Application.DisplayAlerts = True
- End If
-
- Application.ScreenUpdating = False
- For i = 1 To 12
- '求天数
- If i = 12 Then
- arr(i) = Day(DateSerial(Year(Date) + 1, 1, 1) - 1)
- Else
- arr(i) = Day(DateSerial(Year(Date), i + 1, 1) - 1)
- End If
- '添加新的工作表
- r = 8
- Sheets.Add after:=Worksheets(Worksheets.Count)
- ActiveSheet.Name = i & "月"
- '复制数据
- With Sheets(i & "月")
- '天数
- For j = 1 To arr(i)
- .Cells(j + r, 1) = j
- Next j
- .Range("A9:A" & arr(i) + r).Borders.LineStyle = 1
- '标题行
- Sheets(1).Range("A8:E8").Copy Destination:=.Range("A8")
- '记录
- Sheets(1).Range("B9:E" & arr(i) + r).Copy Destination:=.Range("B9")
- End With
- Next i
- Sheets(1).Select
- End Sub
-
复制代码
demo2.rar
(16.62 KB, 下载次数: 34)
|
|