Hi,
I'm a bit inexperience in using arrays, but the paste special value runs a little longer than i would like.
Column A can have 200,000 - 300,000 items .
Is there a way to speedup the below code using Array or an alternative way making the code work faster??
Columns("A:A").Select
Selection.Copy
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Many thanks
M
I'm a bit inexperience in using arrays, but the paste special value runs a little longer than i would like.
Column A can have 200,000 - 300,000 items .
Is there a way to speedup the below code using Array or an alternative way making the code work faster??
Columns("A:A").Select
Selection.Copy
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Many thanks
M