VBA Code for Formula

[OilEconomist]

Thanks in advance for any suggestions for which I will provide feedback.

I am getting an error on the following formula as it's when i added, the "N/A" part for the IFERROR.

Cells(i, 4).Formula = "= IFERROR( MATCH(TRUE,INDEX(Sheet1!E" & i & ":" & LastColumnLtr & i & "<>0,),0)," & ""N/A" )"

An example of the output will be:
= IFERROR( MATCH(TRUE,INDEX(Sheet1!E5:I5<>0,),0), N/A)

 

[shg]

You're welcome.

Don't say that too loud -- then everyone will want to come here.