jillseurre
Technical User
is there any way to set a worksheet to not display div0.
i have a reference sheet with 100's of inputs alot will not be populated. on a result sheet a i have a lot of calcs - and because the ref sheet is not populated i get div0.
i dont want to have to re-enter a formula for errors.
if i have to redo all the formulas - whats the best code for handling all types of error.
i have a reference sheet with 100's of inputs alot will not be populated. on a result sheet a i have a lot of calcs - and because the ref sheet is not populated i get div0.
i dont want to have to re-enter a formula for errors.
if i have to redo all the formulas - whats the best code for handling all types of error.