Excel Cannot Paste all copied cells

Question

So I have around 16.000 cells to copy from one column to another one. If I copy paste it, only the first 1000 cells get pasted, the lower i get in the sheet, the less cells get pasted.

I cannot move & replace the column itself aswell since I m getting the error "This can`tbe done on a multiple range selection".

How can I copy all the cells at once? Thanks in advance

question from:https://stackoverflow.com/questions/66061380/excel-cannot-paste-all-copied-cells

Answer 1

So i solved it over a looped vba:

'
' Macro3 Macro
'
' Keyboard Shortcut: Ctrl+ü
'

For i = 1 To 36430

    Range("L" & i).Select
    Selection.Copy
    Range("M" & i).Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False

Next i
   
End Sub```