|
- Sub 转换格式()
- With Sheets(3)
- [a7:s8].Copy .[a1]
- arr = Range("a9:s" & [a65536].End(3).Row)
- For i = 1 To UBound(arr)
- If i < UBound(arr) - 1 And i >= 2 Then
- If arr(i, 1) = "" Then arr(i, 1) = arr(i - 1, 1)
- If arr(i, 2) = "" Then arr(i, 2) = arr(i - 1, 2)
- If arr(i, 5) = "" Then arr(i, 5) = arr(i - 1, 5)
- End If
- For j = 7 To UBound(arr, 2)
- arr(i, j) = Val(arr(i, j))
- Next
- Next
- .[a3].Resize(UBound(arr), UBound(arr, 2)) = arr
- .[f3].Resize(UBound(arr), UBound(arr, 2) - 4).NumberFormatLocal = "_ * #,##0.00_ ;_ * -#,##0.00_ ;_ * ""-""??_ ;_ @_ "
- .Columns.AutoFit
- .Activate
- End With
- End Sub
复制代码 |
|