I have a section of code that is within a larger vba procedure.
The procedure was fairly slow in executing so I commented out section by section until I found the part that was causing the slow down.
WKS2.Range("A:A").Value = WKS1.Range("J:J").Value
WKS2.Range("B:B").Value = WKS1.Range("M:M").Value
WKS2.Range("C:C").Value = WKS1.Range("O:O").Value
Is there a way of writing this so it executes quicker?
Thanks in advance