I just copied 10522 rows (a subset of 21000 rows) to another workbook with
headers in a different order and had no problem. Exactly what was expected
was copied.

Perhaps you don't have the correct criteria or your ranges are not properly
defined.

Are you sure you mean Advanced Filter. Autofilter only displays 1000 unique
choices in the dropdown as an example, but it can filter all entries.

--
Regards,
Tom Ogilvy



"dbKemp" wrote in message
ups.com...
AdvancedFilter seems to work well when number of rows to be copied is
less than 1000, but when more than 1000 rows are to be copied all of
the rows in the database are copied. Is there a way to get more than
1000 rows at at time?

My application takes rows from one workbook to another after the user
has manually filtered the database. The column headers order may be
different in the source workbook than the destination workbook. I use
a unique key in the criteria range.

The only way I can think of doing this is to do multiple AdvancedFilter
copies and offset the CopyToRange (with headers) and then delete the
headers.

Any suggestions?

Thanks.