Autofilter currently filtering, or just "on"?
 

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

Autofilter currently filtering, or just "on"?
 

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

Autofilter currently filtering, or just "on"?
 

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

Autofilter currently filtering, or just "on"?
 

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