Help to removie #DIV/0! from a fill down formula code.

[swade730]

Hi,

I have this code that fills down formulas to a certain column.
But the issue is if the value is 0 then the cell will show #DIV/0!

How can I adjust the code so that it will show a blanck cell?

Please Login or Register  to view this content.

I have tried entering the formula as iferror as well but that won't work

Any assistance is greatly appreciated

[Norie]

Try this.

Please Login or Register  to view this content.

[ConneXionLost]

How about:

Please Login or Register  to view this content.

Cheers,