Pasting bunch of data on a limited range (Named Range) may be the root cause for this issue

Just select the first cell of that named range and paste so that the data get pasted easily

Try like this...

ActiveSheet.Range("Day_AC_Out").Cells(1).PasteSpecial xlPasteValues