ItalianPlatinum
Well-known Member
- Joined
- Mar 23, 2017
- Messages
- 793
- Office Version
- 365
- 2019
- Platform
- Windows
Hello - I believe my VBA is clocking because of my large dataset and me copying/pasting the below. is anyone able to assist of how to optimize it?
VBA Code:
Application.Run "'_ALL .xlsm'!ALLV"
Application.ScreenUpdating = False
lr = Range("A11").End(xlDown).row
Range("A11:X" & lr).Copy
With Sheets("Pre").Range("A" & rows.count).End(xlUp).Offset(1)
.PasteSpecial Paste:=xlPasteValues
.PasteSpecial Paste:=xlPasteFormats
End With
Application.CutCopyMode = False