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.