In the input Excel document cell C1 having the array formula refer the named range, when copy the range A1:E3 source to destination, the array formula refer named range not copied, so after copied using AddCopy throw the Exception, which cause of this issue.
We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
(Last updated on: June 24, 2019).