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)!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion