The code wouldn't compile with this error.

Depending on the computer's memory and processor, Excel 2007 may work
nearly as quickly as 2003, or it may work vastly slower. Particularly on
"large" data sets, where large is smaller than the capacity of 2003
worksheets.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



Herbert Seidenberg wrote:
Excel 2007
Try
Action:=xlFilterCopy
instead of
Actiion:xlFilterCopy
Tried 500 by 25 array.
Did not notice any delay.
http://www.mediafire.com/file/ymjmkdytozd/11_20_09.xlsm