View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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