whenever i run this vba it takes 10-15 minutes. is there a way to do this quicker or do i have to upgrade my hardware? thanks
Sub Get_Max_And_Min() Dim WB As Workbook Dim A As Long Dim StartFn As Long Dim EndFn As Long StartFn = 30 EndFn = 130 Application.Workbooks.Open ("C:\Users\wolfgang\Desktop\huraa1.xlsb") Application.Workbooks.Open ("C:\Users\wolfgang\Documents\recording.xlsx ") For A = StartFn To EndFn Set WB = Application.Workbooks.Open("C:\Users\wolfgang\Documents\M" & A & ".xlsb ") Windows("huraa1").Activate Range("A2:F94190").ClearContents WB.Activate Range("A1:F94153").Copy Windows("huraa1").Activate Range("A2").End(xlUp).Offset(1).PasteSpecial Paste:=xlPasteValues Application.Calculate WB.Activate Range("G1").Copy Windows("huraa1").Activate Range("BH2").End(xlUp).Offset(1).PasteSpecial Paste:=xlPasteValues Range("BE2:BH3").Copy Windows("recording").Activate Range("A" & Rows.Count).End(xlUp).Offset(1).PasteSpecial Paste:=xlPasteValues Windows("huraa1").Activate Range("A2:F94190").ClearContents WB.Activate Range("A94152:F174675").Copy Windows("huraa1").Activate Range("A2").End(xlUp).Offset(1).PasteSpecial Paste:=xlPasteValues Application.Calculate WB.Activate Range("G1").Copy Windows("huraa1").Activate Range("BH2").End(xlUp).Offset(1).PasteSpecial Paste:=xlPasteValues Range("BE2:BH3").Copy Windows("recording").Activate Range("A" & Rows.Count).End(xlUp).Offset(1).PasteSpecial Paste:=xlPasteValues Application.CutCopyMode = False WB.Close SaveChanges:=False Next End Sub
Bookmarks