I have a vb script that copies comments from a workbook to another one that has cells with array formulas and it's worked fine for months but I just added a line to paste formats as well and I get "You cannot change part of an array" error. Is there a way to make this work? Here is part of my code:

Sub Comments()
Dim x As Workbook
Dim y As Workbook

Set x = Workbooks.Open("**\***.xlsm", UpdateLinks:=xlUpdateLinksNever)
Set y = ThisWorkbook

x.Sheets("Microsoft").Range("E10:AQ1000").Copy

y.Sheets("Microsoft").Range("E10:AQ1000").PasteSpecial Paste:=xlPasteComments
y.Sheets("Microsoft").Range("E10:AQ1000").PasteSpecial Paste:=xlPasteFormats