?CVErr(xlErrDiv0)

[intothewild]

The following code makes me nervous as I don't know how it works (it does 'seem' to work).

In Cell U6 in Sheet calculator I wand to replace any Div 0 error with 0 itself.

Looking for insight on how the bold line below works:

Also there is only one End If !?

 Worksheets("Calculator").Range("U6").Value = "=J6/G6"
 Worksheets("Calculator").Select

 If IsError(Range("U6")) Then

  If Range("U6").Value = CVErr(xlErrDiv0) Then Range("U6").Value = 0

 End If