Autofilter currently filtering, or just "on"?

's Computer Specifications

Hi All......
Could someone please tell me the code to test if the Autofilter is actually
filtering to a criteria NOW, or is it just turned on?

TIA
Vaya con Dios,
Chuck, CABGx3

's Computer Specifications

Hi Jacob......
Not exactly what I was looking for, but thanks for the response.

Vaya con Dios,
Chuck, CABGx3

"Jacob Skaria" wrote:

> turned ON
>
> http://www.contextures.com/xlautofilter01.html
>
> If this post helps click Yes
> ---------------
> Jacob Skaria
>
>
> "CLR" wrote:
>
> > Hi All......
> > Could someone please tell me the code to test if the Autofilter is actually
> > filtering to a criteria NOW, or is it just turned on?
> >
> > TIA
> > Vaya con Dios,
> > Chuck, CABGx3
> >
> >

's Computer Specifications

Hi,

Have a look at this thread where the issue was discussed by Gary's student
and myself.

http://www.microsoft.com/office/comm...ef5&sloc=en-us

Mike

"CLR" wrote:

> Hi Jacob......
> Not exactly what I was looking for, but thanks for the response.
>
> Vaya con Dios,
> Chuck, CABGx3
>
>
> "Jacob Skaria" wrote:
>
> > turned ON
> >
> > http://www.contextures.com/xlautofilter01.html
> >
> > If this post helps click Yes
> > ---------------
> > Jacob Skaria
> >
> >
> > "CLR" wrote:
> >
> > > Hi All......
> > > Could someone please tell me the code to test if the Autofilter is actually
> > > filtering to a criteria NOW, or is it just turned on?
> > >
> > > TIA
> > > Vaya con Dios,
> > > Chuck, CABGx3
> > >
> > >

's Computer Specifications

Thanks Mike.....much appreciate.

Vaya con Dios,
Chuck, CABGx3

"Mike H" wrote:

> Hi,
>
> Have a look at this thread where the issue was discussed by Gary's student
> and myself.
>
> http://www.microsoft.com/office/comm...ef5&sloc=en-us
>
> Mike
>
> "CLR" wrote:
>
> > Hi Jacob......
> > Not exactly what I was looking for, but thanks for the response.
> >
> > Vaya con Dios,
> > Chuck, CABGx3
> >
> >
> > "Jacob Skaria" wrote:
> >
> > > turned ON
> > >
> > > http://www.contextures.com/xlautofilter01.html
> > >
> > > If this post helps click Yes
> > > ---------------
> > > Jacob Skaria
> > >
> > >
> > > "CLR" wrote:
> > >
> > > > Hi All......
> > > > Could someone please tell me the code to test if the Autofilter is actually
> > > > filtering to a criteria NOW, or is it just turned on?
> > > >
> > > > TIA
> > > > Vaya con Dios,
> > > > Chuck, CABGx3
> > > >
> > > >

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
RE: Autofilter currently filtering, or just "on"?	Jacob Skaria	Microsoft Excel Programming	0	14th Apr 2009 01:18 PM
Filtering auto-generated code from "Treat Warnings as Errors" and "XML Comments"	Skip Sailors	Microsoft C# .NET	1	9th Jun 2006 08:26 PM
How do I filtering out messages with empty "to" or "subject" fiel.	=?Utf-8?B?bm9zcGFt?=	Microsoft Outlook Discussion	1	4th Jan 2005 07:45 PM
Security Filtering for specific "Links" instead of "GPO"	Bruce Sanderson	Microsoft Windows 2000 Group Policy	2	12th May 2004 09:26 PM
Re: How can I change the Excel, Autofilter, Custom default from "equals"to "contains"?	Dave Peterson	Microsoft Excel Misc	0	19th Jul 2003 12:48 AM