Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Controlling auto-filter with VBA
I have a question about controlling auto-filter with VBA and
need some help. I hope someone will oblige. I know about Debra Dalgleish's excellent and very helpful pages at http://www.contextures.com -- and specifically the pages to do with auto-filters he http://www.contextures.com/xlautofilter03.html#All But I still am having a problem with Excel XP/2002. Specifically, when I use the suggested code Sub ShowAllRecords() If ActiveSheet.FilterMode Then ActiveSheet.ShowAllData End If End Sub if FilterMode was on but all data is already being shown, I get an error message when I run the macro. I can think of at least three ways to work around the issue. But I'd like to know the suggested solution. What I'm doing right now is (1) checking for |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Controlling auto-filter with VBA
On Thursday, July 5, 2012 10:48:26 AM UTC-5, Dallman Ross wrote:
I have a question about controlling auto-filter with VBA and need some help. I hope someone will oblige. I know about Debra Dalgleish's excellent and very helpful pages at http://www.contextures.com -- and specifically the pages to do with auto-filters he http://www.contextures.com/xlautofilter03.html#All But I still am having a problem with Excel XP/2002. Specifically, when I use the suggested code Sub ShowAllRecords() If ActiveSheet.FilterMode Then ActiveSheet.ShowAllData End If End Sub if FilterMode was on but all data is already being shown, I get an error message when I run the macro. I can think of at least three ways to work around the issue. But I'd like to know the suggested solution. What I'm doing right now is (1) checking for try Sub showall() On Error GoTo away ActiveSheet.ShowAllData away: End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Filter - Custom Auto Filter | Excel Programming | |||
DataFilterAuto Filter in excel 2007? | New Users to Excel | |||
Controlling Auto filter | Excel Programming | |||
Auto Count for Auto Filter Doesn't Function under certain circumst | Excel Discussion (Misc queries) | |||
Excel auto filter doesn't recoginize case - won't filter AA from A | Excel Discussion (Misc queries) |