I have data in various cols
I have written code to copy the data in Col j & Col L and to paste value in S1
I get a run time error-Application-defined or object-defined error
The following code is highlighted
.Range("J1:J, L1:L" & lr).Copy
See full code below
Sub...