I use the following code to filter data in Exel 2003.
Sheets("DevData").Range(SourceDev).AdvancedFilter Actiion:xlFilterCopy,
CriteriaRange:=Sheets("FilterControl").Range(Crite rion2),
CopyToRange:=Sheets("Results").Range("A10:BH10"), Unique:=False.
Range("SourceDev") is about 50,000 row x 52 column.
The macro works perfectly and returns results in about 2 to 3 seconds. The
same code in Excel 2007 locks up. I've tried to running the same code in
smaller workbooks with 2,500 rows and 52 columns. In 2003 I get results in 2
seconds in 2007 it takes 80 to 90 seconds. Any suggestions on code changes
or setting that will help me. Thanks