VBA error 11: Division by zero

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.