Range.Autofilter

Wrox Programmer Forums

		Wrox Programmer Forums > Microsoft Office > Other Office > Visual Studio Tools for Office
Range.Autofilter

Visual Studio Tools for Office Be sure to specify which version you are working with.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the Visual Studio Tools for Office section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

Old

June 3rd, 2009, 05:47 AM

vinodjv

vinodjv is offline

Authorized User

Join Date: Jul 2008

Posts: 11

Thanks: 0

Thanked 0 Times in 0 Posts

Default

Range.Autofilter

Hi,

I am using a code Range.Autofilter to set the autofilter.

In excel 2007 , it is taking lot of time when it runs..

but in excel 2003 it is working faster....

any idea.....

Old

August 1st, 2009, 09:28 PM

Shasur

Shasur is offline

Friend of Wrox

Join Date: Sep 2005

Posts: 812

Thanks: 1

Thanked 53 Times in 49 Posts

Default

Can you post the code snippet you are using.

It could provide some insight

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Autofilter, multiselect, 2007	SteveB	Excel VBA	0	March 5th, 2009 08:32 PM
Enter Criteria Above Header To apply Autofilter	stroggo	Excel VBA	2	April 16th, 2008 03:35 AM
Remove Autofilter	yogeshyl	Excel VBA	4	June 11th, 2007 06:59 AM
AutoFilter 5 columns at once	Pindacko	Excel VBA	0	April 26th, 2006 05:33 AM
Autofilter taking too much of time	raaghu15	Excel VBA	2	March 4th, 2005 05:43 PM