|
变通一下。
- Sub test()
- Dim r&, rng As Range
- r = Cells(Rows.Count, 1).End(3).Row
- Application.ScreenUpdating = False
- Set rng = Range("a3:p" & r).SpecialCells(xlCellTypeBlanks)
- rng = 0
- Columns("a").NumberFormatLocal = "000000"
- Union(Columns("h"), Columns("l:o")).NumberFormatLocal = "0.00"
- Range("h3:h" & r) = Evaluate("""=text(""&h3:h" & r & "&"",""""0.00"""")*1""")
- Union(Columns("j:k"), Columns("p")).NumberFormatLocal = "yyyy-mm-dd"
- Union(Range("j3:k" & r), Range("p3:p" & r)).Replace "T00", ""
- Range("l3:m" & r) = Evaluate("""=text(""&l3:m" & r & "&""/10^4,""""0.00"""")*1""")
- Range("n3:o" & r) = Evaluate("""=text(""&n3:o" & r & "&""/10^8,""""0.00"""")*1""")
- UsedRange = UsedRange.Value
- rng = ""
- Application.ScreenUpdating = True
- MsgBox "Done!"
- End Sub
复制代码 |
|