lior03
01-07-2008, 02:16 AM
hello
this code loops through every cell in used range detects error and report both the cell address(errored cells only)and the type of error.
Dim cell As Range
For Each cell In ActiveSheet.UsedRange
If IsError(cell) Then
MsgBox cell.Address & " - contain error" & CVErr(cell), vbInformation, "error handler"
End If
Next
how can i tell the user the type of error hehas through vba?
thanks
this code loops through every cell in used range detects error and report both the cell address(errored cells only)and the type of error.
Dim cell As Range
For Each cell In ActiveSheet.UsedRange
If IsError(cell) Then
MsgBox cell.Address & " - contain error" & CVErr(cell), vbInformation, "error handler"
End If
Next
how can i tell the user the type of error hehas through vba?
thanks