Hi,
I'm having this code to copy paste rows and columns , and it works, but due to numbers of rows are over 10K lines. it is taking very long time to run, anyway to correct this with dynamic code?
![]()
Sheets("ALL").Activate Range("O2:AJ2").Select Selection.Copy Range("M" & Rows.count).End(xlUp).Select ActiveCell.Offset(0, 2).Select ActiveSheet.Paste Range("M2:AJ2").Select Selection.Copy Range(Selection, Selection.End(xlDown)).Select ActiveSheet.Paste
Bookmarks