Error Handler #DIV/0!

[Shahzadt]

I have a VBA code that loops through a range of cells and inputs a value of a calculation however sometimes the code throws an error DIV/0 is there a way to tell vba that DIV/0 = 0?

 

[Asator]

if divisor <> 0 then
  whatever = yourcalculation
else
 whatever = 0
end if

Like that?

 

[Shahzadt]

Yes but i have multiple routines in a module and i was wondering if there was a way to enter this on a module level rather then a sub level. something like on error go to errorhandler; errorhandler: is err.number = 11 then assign 0 to whatever cell is being worked on or whatever variable to value is going to be attached to.