Sub test()
Dim vArr, i&, j&
vArr = Range("A2", Cells(Rows.Count, 2).End(3))
For i = 3 To UBound(vArr)
For j = 1 To UBound(vArr, 2)
If IsError(vArr(i, j)) Then
vArr(i, j) = 0
ElseIf Len(vArr(i, j)) = 0 Then
vArr(i, j) = 0
End If
Next
Next
Range("A2").Resize(UBound(vArr), 2) = vArr
MsgBox "OK"
End Sub
点击文件名下载附件
Sub TEST()
For i = 4 To UsedRange.Rows.Count + 1
If Cells(i, 1).Text = "#VALUE!" Then Cells(i, 1) = 0
If Cells(i, 2).Text = "#VALUE!" Then Cells(i, 2) = 0
If Cells(i, 1) = "" Then Cells(i, 1) = 0
If Cells(i, 2) = "" Then Cells(i, 2) = 0
Next
End Sub