AdvancedFilter property?
in [Programming]
|
From: Ted M H on 11 May 2010 13:03 Thanks for the information. The autofilter stuff is mostly irrelevant to my question, which is about advanced filter. "ryguy7272" wrote: > Take a look at this: > http://www.contextures.com/xlautofilter03.html > > > -- > Ryan--- > If this information was helpful, please indicate this by clicking ''Yes''. > > > "Ted M H" wrote: > > > I need a way to clear any and all AdvancedFilter on a worksheet so that all > > rows are displayed. I've tried the ShowAllData method and it works fine as > > long as there are filtered rows on the sheet. But the method fails if there > > are no filtered rows. > > > > Is there a way ShowAllData regardless of whether rows are filtered? If not, > > is there a way to check for AdvancedFilter--a sort of AdvancedFilter property? > > > > Many thanks. > > > > > >
From: Ted M H on 11 May 2010 13:12 Thanks a million for the quick replies. I ended up going with the on error resume next option. I didn't realize that the worksheet.filtermode property applied to either autofilter or advanced filter. Now I know. Much obliged. "Ted M H" wrote: > I need a way to clear any and all AdvancedFilter on a worksheet so that all > rows are displayed. I've tried the ShowAllData method and it works fine as > long as there are filtered rows on the sheet. But the method fails if there > are no filtered rows. > > Is there a way ShowAllData regardless of whether rows are filtered? If not, > is there a way to check for AdvancedFilter--a sort of AdvancedFilter property? > > Many thanks. > > >
From: Rick Rothstein on 11 May 2010 13:17 > ...If not, is there a way to check for AdvancedFilter...? If you would have looked through the code samples at the link that Ryan provided, I think you might have found the answer to the above question in the "Turn On Excel AutoFilter" example. -- Rick (MVP - Excel) "Ted M H" <TedMH(a)discussions.microsoft.com> wrote in message news:F065ECAB-C6CD-4454-9571-36A597C7D9C2(a)microsoft.com... > Thanks for the information. The autofilter stuff is mostly irrelevant to > my > question, which is about advanced filter. > > "ryguy7272" wrote: > >> Take a look at this: >> http://www.contextures.com/xlautofilter03.html >> >> >> -- >> Ryan--- >> If this information was helpful, please indicate this by clicking >> ''Yes''. >> >> >> "Ted M H" wrote: >> >> > I need a way to clear any and all AdvancedFilter on a worksheet so that >> > all >> > rows are displayed. I've tried the ShowAllData method and it works >> > fine as >> > long as there are filtered rows on the sheet. But the method fails if >> > there >> > are no filtered rows. >> > >> > Is there a way ShowAllData regardless of whether rows are filtered? If >> > not, >> > is there a way to check for AdvancedFilter--a sort of AdvancedFilter >> > property? >> > >> > Many thanks. >> > >> > >> >
From: Ted M H on 11 May 2010 23:45 Hi Rick, I'm not sure what your point is, but I sure don't see the answer in these code samples. The Turn on Excel AutoFilter example definitely does not provide the answer. Again, my question was about Advanced Filter and the AutoFilterMode property has nothing to do with Advanced Filter. Thanks for your interest, though. "Rick Rothstein" wrote: > > ...If not, is there a way to check for AdvancedFilter...? > > If you would have looked through the code samples at the link that Ryan > provided, I think you might have found the answer to the above question in > the "Turn On Excel AutoFilter" example. > > -- > Rick (MVP - Excel) > > > > "Ted M H" <TedMH(a)discussions.microsoft.com> wrote in message > news:F065ECAB-C6CD-4454-9571-36A597C7D9C2(a)microsoft.com... > > Thanks for the information. The autofilter stuff is mostly irrelevant to > > my > > question, which is about advanced filter. > > > > "ryguy7272" wrote: > > > >> Take a look at this: > >> http://www.contextures.com/xlautofilter03.html > >> > >> > >> -- > >> Ryan--- > >> If this information was helpful, please indicate this by clicking > >> ''Yes''. > >> > >> > >> "Ted M H" wrote: > >> > >> > I need a way to clear any and all AdvancedFilter on a worksheet so that > >> > all > >> > rows are displayed. I've tried the ShowAllData method and it works > >> > fine as > >> > long as there are filtered rows on the sheet. But the method fails if > >> > there > >> > are no filtered rows. > >> > > >> > Is there a way ShowAllData regardless of whether rows are filtered? If > >> > not, > >> > is there a way to check for AdvancedFilter--a sort of AdvancedFilter > >> > property? > >> > > >> > Many thanks. > >> > > >> > > >> > > . >
From: ozgrid.com on 11 May 2010 23:51 You can use; Sub RemoveFilters() On Error Resume Next Sheet1.ShowAllData On Error GoTo 0 End Sub -- Regards Dave Hawley www.ozgrid.com "Ted M H" <TedMH(a)discussions.microsoft.com> wrote in message news:E3A9BF2F-2B54-49D8-AB20-87C2B03750AB(a)microsoft.com... > Hi Rick, > > I'm not sure what your point is, but I sure don't see the answer in these > code samples. The Turn on Excel AutoFilter example definitely does not > provide the answer. Again, my question was about Advanced Filter and the > AutoFilterMode property has nothing to do with Advanced Filter. > > Thanks for your interest, though. > > "Rick Rothstein" wrote: > >> > ...If not, is there a way to check for AdvancedFilter...? >> >> If you would have looked through the code samples at the link that Ryan >> provided, I think you might have found the answer to the above question >> in >> the "Turn On Excel AutoFilter" example. >> >> -- >> Rick (MVP - Excel) >> >> >> >> "Ted M H" <TedMH(a)discussions.microsoft.com> wrote in message >> news:F065ECAB-C6CD-4454-9571-36A597C7D9C2(a)microsoft.com... >> > Thanks for the information. The autofilter stuff is mostly irrelevant >> > to >> > my >> > question, which is about advanced filter. >> > >> > "ryguy7272" wrote: >> > >> >> Take a look at this: >> >> http://www.contextures.com/xlautofilter03.html >> >> >> >> >> >> -- >> >> Ryan--- >> >> If this information was helpful, please indicate this by clicking >> >> ''Yes''. >> >> >> >> >> >> "Ted M H" wrote: >> >> >> >> > I need a way to clear any and all AdvancedFilter on a worksheet so >> >> > that >> >> > all >> >> > rows are displayed. I've tried the ShowAllData method and it works >> >> > fine as >> >> > long as there are filtered rows on the sheet. But the method fails >> >> > if >> >> > there >> >> > are no filtered rows. >> >> > >> >> > Is there a way ShowAllData regardless of whether rows are filtered? >> >> > If >> >> > not, >> >> > is there a way to check for AdvancedFilter--a sort of AdvancedFilter >> >> > property? >> >> > >> >> > Many thanks. >> >> > >> >> > >> >> > >> . >>
First
|
Prev
|
Next
|
Last
Pages: 1 2 3 Prev: FOR EACH NEXT Multithreaded ! Next: require cell input before macro can run |