acsishere
05-22-2008, 10:38 AM
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.
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.