espenskeie
Well-known Member
- Joined
- Mar 30, 2009
- Messages
- 636
- Office Version
- 2016
- Platform
- Windows
Hello
Is there anyone who could tell my why this code is very slow? I copy columns from one book to another:
Regards
Espen
Is there anyone who could tell my why this code is very slow? I copy columns from one book to another:
Code:
Sub KopierProdukter()
Windows("Produktliste.xlsm").Activate
Sheets("Produktliste").Select
Range("C:C, L:L, U:U, AD:AD, AM:AM, AV:AV, BE:BE, BN:BN").Select
Selection.Copy
Windows("Prisliste.xlsm").Activate
Sheets("Sheet2").Select
Range("C1").Select
ActiveSheet.Paste
Workbooks("Prisliste.xlsm").Activate
ActiveWorkbook.Save
ActiveWorkbook.Close
End Sub
Regards
Espen