|
Sub 记录在案()
Dim rg As Range
Set rg = Sheets("最小不平衡操作记录").Range("A65536").End(xlUp).Offset(1#)
rg = "=today()"
With rg
.Offset(0, 1) = ActiveSheet.Cells(2, 3)
.Offset(0, 2) = ActiveSheet.Cells(4, 2)
.Offset(0, 3) = ActiveSheet.Cells(4, 4)
.Offset(0, 4) = ActiveSheet.Cells(4, 5)
.Offset(0, 5) = ActiveSheet.Cells(7, 5)
.Offset(0, 7) = ActiveSheet.Cells(7, 9)
End With
End Sub
Set rg = Sheets("最小不平衡操作记录").Range("A65536").End(xlUp).Offset(1)’下移一行的单元格!
|
|