|
- Sub 添加()
- Dim Rng As Range
- rq = [h4] & Format([j4], "00") & Format([L4], "00") '日期
- With Sheet3
- Set Rng = .UsedRange.Find(rq, lookat:=xlPart) '日期是否已存在
- If Rng Is Nothing Then
- r = .[a65536].End(3).Row + 2
- .[a1:f2].Copy .Cells(r, 1)
- .Cells(r, 1) = rq & "交易日志"
- r = r + 2
- Else
- r = .Cells(Rng.Row, 1).End(xlDown).Row + 1
- .Rows(r).Insert
- End If
- .Cells(r, 1).Resize(1, 6) = Array([L5], [H5], [H6], [J6], [L6], Left([L8], Len([L8]) - 1))
- End With
- MsgBox "已添加!"
- End Sub
复制代码 |
|