Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 92
Default Re : Excel After-Life for an AutoFilter upon VisibleDropDown;=False

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).Visibl eDropDown,
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.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
What's the best way to toggle between true and false in Excel? Hiall, My excel work involves a lot of toggling between true and false (booleantypes) ... and it's very repetitive... Is there a way to select a bunch ofcells, and press a key short-cu LunaMoon Excel Discussion (Misc queries) 9 July 29th 08 12:28 AM
VBA always creates linked chart even when using PasteExcelTable False, False, False in Office 2007 Matt Simpson Excel Programming 0 August 6th 07 08:11 PM
End Of Life Support Excel 95 Larry R[_3_] Excel Programming 1 May 17th 07 10:02 PM
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) RICHARD Excel Worksheet Functions 1 March 15th 05 05:49 PM
autofilter true/false Confused Individual Excel Programming 1 February 18th 04 09:48 PM


All times are GMT +1. The time now is 05:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"