xlDown Macro copying 1 million+ blank cells

[KGEORGE13]

hello,

I have a database workbook with about 10 pages of VBA code. The purpose of most of the codes is to filter through a table and find unique parts and paste them into another table. I use the "xlDown" code a lot when copying the given range of the table needed to copy, but I've come to find out that when the code finds no end, it pastes 1 million cells.

Is there any easy fix in the VBA code for this?

Thank you!

 

[Joe4]

Have you ever tried the "Filter to a New Location" option?

See here: http://www.contextures.com/xladvfilter01.html