I read on a website tutorial that a more efficient way of copying and pasting ranges was to use the following:
' This is faster
Range("A1:A10").Value = Range("B1:B10").Value
' This is slower
Range("B1:B1").Copy Destination:=Range("A1:A10")
I was led to believe this way made the code run...