I'm looking for faster VBA code that will copy abt 300,000 rows of data from a closed workbook to an active workbook. Currently I'm using code like the following which isn't that fast.
Workbooks.Open Filename:=strpath & totalfile
Sheets("PROD").Select
Sheets("PROD").Copy After:=Workbooks(OpNumfile).Sheets("LOS")
Cells.Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
thanks.
Workbooks.Open Filename:=strpath & totalfile
Sheets("PROD").Select
Sheets("PROD").Copy After:=Workbooks(OpNumfile).Sheets("LOS")
Cells.Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
thanks.