数据中 12296 行不为数字!,修改语句:
Sub 数据取值1()
Application.ScreenUpdating = False
Sheet1.Activate
Dim arr
Dim i As Long
arr = Range("A2:H" & Cells(Rows.Count, 1).End(xlUp).Row) 'C为输出结
For i = 2 To UBound(arr) '不包含标题
If IsNumeric(arr(i, 7)) Then arr(i, 8) = Abs(arr(i, 7))
Next
Range("a2:H" & Cells(Rows.Count, 1).End(xlUp).Row) = arr
Application.ScreenUpdating = True
End Sub