Autofilter currently filtering, or just "on"?

[CLR]

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

 

[CLR]

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

Vaya con Dios,
Chuck, CABGx3

 

[Mike H]

Hi,

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

http://www.microsoft.com/office/com...f607ed-81ae-4807-a751-116a3286bef5&sloc=en-us

Mike

 

[CLR]

Thanks Mike.....much appreciate.

Vaya con Dios,
Chuck, CABGx3