v2401 creates "Clipboard error" in macros

https://learn.microsoft.com/en-us/officeupdates/current-channel?redirectSourcePath=%252farticle%252f95c8d81d-08ba-42c1-914f-bca4603e1426 for the 30 Jan 2024 release (Build 17231.20182) include this c...

excel

Macros and VBA

JKPieterse

Silver Contributor

Feb 07, 2024

bookstaber

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.

2. Perhaps a more efficient way of doing the copying helps:

    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

JerryM81
Copper Contributor
Jun 28, 2024
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

Resources