Results 1 to 3 of 3
  1. #1
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Switch off Autofilter (WinNT4, Excel97)

    Try

    ActiveSheet.AutoFilterMode = False

    AutoFilterMode indicates whether there is an AutoFilter active on the specified worksheet (there can be only one AutoFilter active on a sheet)

    BTW, you can edit the subject of your post to mention Excel instead of Word.

  2. #2
    Super Moderator
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    3,852
    Thanks
    4
    Thanked 259 Times in 239 Posts

    Re: Switch off Autofilter (WinNT4, Word97)

    <P ID="edit" class=small>(Edited by Andrew Lockton on 17-Aug-05 21:42. )</P>Have you tried - ActiveSheet.AutoFilterMode = False

    Perhaps this link is of some use to you where the code shows you how to also reveal remove the filtering a thread on http://groups.google.com.au/group/microsof...xcel.misc?hl=en

    Too slow again - Hans beat me to it
    Andrew Lockton, Chrysalis Design, Melbourne Australia

  3. #3
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Morden, Surrey, United Kingdom
    Posts
    1,838
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Switch off Autofilter (WinNT4, Excel97)

    Edited to add - Sorry, this is XL97, of course, not Word97!

    I'm trying to work with a spreadsheet that often has the AutoFilter turned on, but in order to work with the data I need it to be switched off (if it's on). For some reason however the normal ways (or the ways I usually use) don't seem to work!

    Something like: "if ActiveCell.CurrentRegion.AutoFilter = true then ActiveCell.CurrentRegion.AutoFilter = False" was what I thought would work, but XL just keeps complaining that it is "unable to set the autofilter property of the range class".

    Presumably I'm wording this wrong, but I can't seem to track down the correct wording! Could someone set me on the right track, please?!

    Many thanks!
    Beryl M


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •