|
- Sub demo()
- Dim ar, i
- ar = Range("a2:e" & Cells(Rows.Count, 1).End(3).Row)
- For i = 1 To UBound(ar)
- ar(i, 2) = ar(i, 3) - 0.3
- ar(i, 4) = ar(i, 5) - 0.3
- Next
- Range("a2").Resize(UBound(ar), UBound(ar, 2)) = ar
- Columns("b:e").NumberFormatLocal = "yyyy-m-d"
- End Sub
复制代码 附件楼下
|
|