Migrating to Excel 2007


R

RussellT

I use the following code to filter data in Exel 2003.
Sheets("DevData").Range(SourceDev).AdvancedFilter Actiion:xlFilterCopy,
CriteriaRange:=Sheets("FilterControl").Range(Criterion2),
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
 
Ad

Advertisements

Ad

Advertisements

J

Jon Peltier

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top