Move or Copy Duplicate Rows to Difference Sheet

[Gary's Student]

You are running out of memory because you are creating massive arrays in VBA when capturing and copying UsedRange. You may need to process one row at a time.