|
请参考
Sub te3st()
Dim rng As Range
Range("B1:AG102").Clear
da = DateAdd("m", 1, CDate([A1])) - 1
For j = 1 To Day(da)
Cells(2, j + 1) = j
Next
Cells(2, Columns.Count).End(1).Offset(, 1) = "小计"
If Cells(Rows.Count, 1).End(3).Offset(0) <> "合计" Then
Set rng = [A2].CurrentRegion.Offset(1)
rng.Borders().LineStyle = xlContinuous
Cells(Rows.Count, 1).End(3).Offset(1) = "合计"
Else
Set rng = [A2].CurrentRegion.Offset(0)
rng.Borders().LineStyle = xlContinuous
End If
Rows("1:1").Borders().LineStyle = xlNone
End Sub
|
评分
-
1
查看全部评分
-
|