I have this;
Windows("file1.xlsx").Activate
Range("F4:F500").Select
Application.CutCopyMode = False
Selection.Copy
Windows("file2.xlsm").Activate
Range("L2").Select
ActiveSheet.Paste
I'm sure this can be reduced somewhat - any suggestions?
Thanks![Smile :-) :-)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
Windows("file1.xlsx").Activate
Range("F4:F500").Select
Application.CutCopyMode = False
Selection.Copy
Windows("file2.xlsm").Activate
Range("L2").Select
ActiveSheet.Paste
I'm sure this can be reduced somewhat - any suggestions?
Thanks
![Smile :-) :-)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)