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.
|