Why is Copy Paste so slow???

[actorcat2000]

copy and paste used to be blazing fast in vba, now it's extremely slow,,, i actually reset my computer, redownloaded microsoft office and it's still slow... is there an update that did this, is this happening to anybody else??? code looks like this:
Selection.Copy
Columns("I:I").Select
Selection.PasteSpecial Paste:=xlPasteAllUsingSourceTheme, Operation:=xlNone _
, SkipBlanks:=False, Transpose:=False
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
video:

 

[6StringJazzer]

Was this exact same code blazing fast? Or just pasting in general?

My first suggestion would be to copy only the used cells instead of the entire column.

 

[actorcat2000]

yes, code never changed, just speed of copying and pasting... i did turn on clipboard history,,, i think it slowed after that, but then i turned it off again and it never sped back up... i've never turned clipboard history on after reset...

 

[actorcat2000]

Was this exact same code blazing fast? Or just pasting in general?

My first suggestion would be to copy only the used cells instead of the entire column.

yes, code never changed, just speed of copying and pasting... i did turn on clipboard history,,, i think it slowed after that, but then i turned it off again and it never sped back up... i've never turned clipboard history on after reset... this is more of a microsoft question, but before i reset, the clipboard history never would work, so i added to the registry to get it to work,,, do you get a new registry when you reset but keep your files, or do you keep the old one??? if not then i'm going to have to reset without keeping files...

 

[6StringJazzer]

I'm not following your question about the registry.

i added to the registry to get it to work,,, do you get a new registry when you reset but keep your files, or do you keep the old one?

Added what to the registry? Reset what? Which files?

 

[actorcat2000]

I'm not following your question about the registry.

Added what to the registry? Reset what? Which files?

i reset the computer, but kept all my files,,, would that include the registry?? if so, then i would have to reset it back to factory...

 

[6StringJazzer]

You mean reset to a prior checkpoint? That almost certainly includes resetting the registry to a prior checkpoint as well. I am completely unclear on what you did to the registry and why you are concerned about it.

 

[actorcat2000]

You mean reset to a prior checkpoint? That almost certainly includes resetting the registry to a prior checkpoint as well. I am completely unclear on what you did to the registry and why you are concerned about it.

no i reset the computer back to factory...