Results 1 to 15 of 15

Turning off AutoFilter via VBA does not seem to work for this file.

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-01-2007
    Location
    USA-North Carolina
    MS-Off Ver
    MS Office 2016
    Posts
    2,669

    Turning off AutoFilter via VBA does not seem to work for this file.

    Hi, i am enclosing a file. When i try to turn off auto filters on this file ......nothing happens.

    I used the following code to turn off autofilters but it does not work:


       With Workbooks(wrkbookname1).Worksheets(wrksheetname1)
            If .AutoFilterMode Then .AutoFilterMode = False
        End With

    Any ideas why? This file seems different in some way.......any ideas?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1