hi,
i am using below code to get link value based on cell
i want to add IFERROR formula before above formula like below![]()
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"
![]()
"=IFERROR('Z:\42766\Jan 2 Dec 2014\1.12.16\[2.7.17.xlsb]SUMALL'!R1C[-1],"""")"
thank you
Bookmarks