VBA error 11: Division by zero

Cause:

VBA calculation is trying to divide by 0 which is not possible.

Solution:

To correct this error
1.Check the spelling of variables in the expression. A misspelled variable name can implicitly create a numeric variable that is initialized to zero.
2.Check previous operations on variables in the expression, especially those passed into the procedure as arguments from other procedures.

Interested in learning new skills?