View Single Post
  #3   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 for responding to the query.

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

You have suggested to test by,

"ActiveSheet.Row(5).AutoFilterMode = False".

But, why Row(5) ?

Nevertheless, having tested your suggestion, it shows exception.

Please share your experience (of tracking the States of
VisibleDropDown of an AutoFilter after being cyclically toggled by,
VisibleDropDown:= False and
VisibleDropDown:= True,
via VBA).

That's when the AutoFilter's Arrow disappears and then reappears
consecutively.

Also, there are several AutoFilter.Filters being implemented on the
ActiveSheet.

Regards.