View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
[email protected] tkt_tang@hotmail.com is offline
external usenet poster
 
Posts: 92
Default Re : Excel AutoFilter being Toggled of VisibleDropDown

Mr. Mitesh Khatri,

Thank you again for responding to the query.

The query case refers to "ActiveSheet.AutoFilter.Filter(1)".

Note that it is Filter(1) of the AutoFilter embedded on an
ActiveSheet.

Specificially, the Arrow-Button of Filter(1) has been subject to the
effect of a Pertinent Argument Setting namely, VisibleDropDown =
False ; and so, it has disappeared from the Lower Right-Hand-Side
Corner of the Header-Cell atop the column of Filter(1).

Meaning that it is One Arrow-Buitton of Filter(1) having
disappeared ...... and there, it is so required to Test (and Track,
via VBA Coding) the State of that Arrow-Button.

You have suggested to test by,

If Not myworksheet.AutoFilterMode Then
myworksheet.Rows(RowNo).AutoFilter() ............

The statement wreaks an effect and there, so many Arrow-Button(s)
would Emerge Enmasse ...... the result is apparently not at all
relevant to the query case.

You see?! the disappearance of an Arrow-Button (amidst several others
thereof) as a result of VisibleDropDown = False does not suffice the
Negation of AutoFilterMode.

In practice, AutoFilterMode = False is the Negation of an (existing)
AutoFilter implemented on an ActiveSheet.

In the meantime, the pursuit to track the State of Arrow-Button of
such AutoFilter.Filter(1) (being Toggled to Dis-Appear and Re-Appear)
persists ; It's Not Over Until It Is Over.

Regards.