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
Bookmarks