T
tkt_tang
Re : Excel After-Life for an AutoFilter upon VisibleDropDown:=False
1. Upon executing the following code,
Sub HideDropDown()
With ActiveSheet.UsedRange
.AutoFilter Field:=2, VisibleDropDown:=False
End With
End Sub
Needless to say, the corresponding button vanishes before our eyes.
2. What has (EXACTLY) happened to, .AutoFilter Field:=2 ?
3. In that, computation of,
ActiveSheet.UsedRange.AutoFilter.Filters.Count,
would cause an Exception.
4. Most importantly, how could it be TEST'd (in all that ensuing code
thereinafter) that ,
..AutoFilter Field:=2,
has indeed been subject to the condition of,
VisibleDropDown:=False ?
5. Meaning that (in order to exemplify),
ActiveSheet.UsedRange.AutoFilter.Filters(2).VisibleDropDown,
would be evaluated TRUE ...... but, must hasten to say that the given
statement is not acceptable by Excel VBA.
6. The query pursues a means to Detect the State of an AutoFilter
after being VisibleDropDown:=False'd.
7. Please comment and share your experience.
8. Regards.
1. Upon executing the following code,
Sub HideDropDown()
With ActiveSheet.UsedRange
.AutoFilter Field:=2, VisibleDropDown:=False
End With
End Sub
Needless to say, the corresponding button vanishes before our eyes.
2. What has (EXACTLY) happened to, .AutoFilter Field:=2 ?
3. In that, computation of,
ActiveSheet.UsedRange.AutoFilter.Filters.Count,
would cause an Exception.
4. Most importantly, how could it be TEST'd (in all that ensuing code
thereinafter) that ,
..AutoFilter Field:=2,
has indeed been subject to the condition of,
VisibleDropDown:=False ?
5. Meaning that (in order to exemplify),
ActiveSheet.UsedRange.AutoFilter.Filters(2).VisibleDropDown,
would be evaluated TRUE ...... but, must hasten to say that the given
statement is not acceptable by Excel VBA.
6. The query pursues a means to Detect the State of an AutoFilter
after being VisibleDropDown:=False'd.
7. Please comment and share your experience.
8. Regards.