I got this error -#DIV/0! on certain cells while running this a macro. I knew the source of the error but wants the macro to run to end without stopping. Please what error handling routine can apply?
In your macro, check if any of the divisor cells are empty or zero, and
skip those in the macro. IOW, whatever the macro does then make it
conditional on the ref'd ranges not being empty (same as Value=0)!