v2401 creates "Clipboard error" in macros

Question

Release notes for the 30 Jan 2024 release (Build 17231.20182) include this comment: "We fixed an issue where the Clipboard Locked Alert is disrupting the workflow for some users."&nbsp;But with that update installed, some of my XLSB workbooks with macros frequently produce the following error when running macros that copy and paste:&nbsp;An example of a macro section that produces the error is&nbsp;the following. The larger the number of iterations (e.g., over 100), the more likely it is to produce the Clipboard Error:&nbsp;&nbsp;    Do While Not IsEmpty(Cells(tRow, 1).Value) 
        Cells(1, popCol).Value = Cells(tRow, 1).Value
        Range("E2:K2").Select 
        Selection.Copy 
        Cells(2, popCol).Select 
        ActiveSheet.Paste 
        Application.CutCopyMode = False 
         
        popCol = popCol + 8 
        tRow = tRow + 1 
    Loop  &nbsp;&nbsp;(It is particular to this latest release: I reverted to v16.0.17126.20132 and the problem disappeared.)

jkpieterse · Answer

bookstaber&nbsp;Two tips.1. When that error appears again, take a screenshot of it and paste it into the workbook. Then click Help, Feedback and select I don't like something and explain the issue like you did here.&nbsp;2. Perhaps a more efficient way of doing the copying helps:&nbsp;    Do While Not IsEmpty(Cells(tRow, 1).Value) 
        Cells(1, popCol).Value = Cells(tRow, 1).Value
        Range("E2:K2").Copy Cells(2, popCol)
        popCol = popCol + 8 
        tRow = tRow + 1 
    Loop
    Application.CutCopyMode = False          &nbsp;

jerrym81 · Answer

Did anyone ever resolve this? I've had this also and I use the form "Range.Copy Cells(...)".

Forum Discussion

v2401 creates "Clipboard error" in macros

2 Replies

Resources