|
1学分
本帖最后由 18839208898 于 2022-11-11 13:47 编辑
哪位高手能帮忙看下添加VbA代码,一点运行,会自动在A列时间列写入三行下一天的日期,B列写入三行同样的科目代码么?在线求助,先谢谢了
Sub 三天三行()
Dim ir As Integer, d As Date
ir = Cells(Rows.Count, 1).End(3).Row + 1
For k = ir To ir + 9 Step 3
d = Cells(Rows.Count, 1).End(3)
Cells(k, 1) = d + 1: Cells(k, 2) = "600102"
Cells(k + 1, 1) = d + 1: Cells(k + 1, 2) = "600106"
Cells(k + 2, 1) = d + 1: Cells(k + 2, 2) = "600101"
Next k
End Sub
|
最佳答案
查看完整内容
Sub 三天三行()
Dim ir As Integer, d As Date
ir = Cells(Rows.Count, 1).End(3).Row + 1
For k = ir To ir + 9 Step 3
d = Cells(Rows.Count, 1).End(3)
Cells(k, 1) = d + 1: Cells(k, 2) = "600102"
Cells(k + 1, 1) = d + 1: Cells(k + 1, 2) = "600106"
Cells(k + 2, 1) = d + 1: Cells(k + 2, 2) = "600101"
Next k
End Sub
|