Copy cell value copies source range’s value as #NAME

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).

[divider]
Recommended Posts

Leave a Comment

Contact Us

To learn more about SolveXia, please use the form below to send us an email. One of our team members will contact you.

Not readable? Change text. captcha txt

Start typing and press Enter to search