hi,
i am using below code to get link value based on cell


Let Range("E" & i & ":F" & i & "").Value = "='Z:\42766\Jan 2 Dec 2014\1.12.16\[" & Cells(i, "D").Value & ".7.17.xlsb]SUMALL'!D$1"
i want to add IFERROR formula before above formula like below
"=IFERROR('Z:\42766\Jan 2 Dec 2014\1.12.16\[2.7.17.xlsb]SUMALL'!R1C[-1],"""")"

thank you