add IF(ISERROR to VB code to eliminate #DIV/0 error

[redspanna]

Hello all

Can anyone suggest how to add an IF(ISERROR function into my line of code below that will show a zero instead of a #DIV/0 error

.Range("L" & NextRow).Formula = "=SUM(L2:L" & NextRow - 1 & ")/('Report data'!$D$3-(COUNTIF(L2:L" & NextRow - 1 & ",""NA"")))"

thanks in advance

 

[BarryL]

maybe

"=IFERROR(SUM(L2:L" & NextRow - 1 & ")/('Report data'!$D$3-(COUNTIF(L2:L" & NextRow - 1 & ",""NA""))),"""""

 

[redspanna]

I'll give that a try - thanks