Dear Friends,

I have a macro to do a process in which the following code appears.

.FormulaR1C1 = "=SUM(R[-1]C/R[-1]C5*100)"
When it is run, if the value is not there, then it shows the #DIV0! Error.
Can any one help me to avoid this Error.

Generally, in worksheet we apply the = IF(ISERROR(SUM(......) formula. I don't know how to apply this kind of formula with the above code.

Your kind help is very much needed. Please....

Thanks in advance.

acsishere.