Hi

I have been going around and around with this. I have finally isolated my
problem as being the insertion formula. I suspect my problem is the
formatting of either the Indirect, VLookup or the named range. Is there
something special I need to do to insert these via code? Everything I've
tried so far has not worked.

Thanks

My formula:
=IF(ISBLANK($J36),"",IF($J36="No",0,INDIRECT(VLOOK UP('Line
Items'!$C15,CAMPerCentLoc,3,FALSE))))

My insert formula:
"=IF(ISBLANK(R" & iCtr & "C10),"""",IF(R" & iCtr & "C10" & "=""No""," & _
"0, Indirect(Vlookup('Line Items'!$R" & iCtr - 21 &
"C3,CAMPerCentLoc,3,False)))"