Copy cell value copies source range’s value as #NAME in target worksheet, when source range contains IFERROR() formula.
Why does this happen?
This is known limitation of the function at the moment. However, please use the suggested workaround until issue has been addressed properly.
How to fix this
Instead of using formula as =IFERROR(A1,0), please use =IF(ISERROR(A1),”Has Error”,A1).