+ Reply to Thread
Results 1 to 2 of 2

Unfilter data and then filter again

Hybrid View

  1. #1
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,095

    Unfilter data and then filter again

    hi,
    i am using this code to unfilter data if it is on filter mode,
    If Worksheets("SUMALL").FilterMode Then
    
      Worksheets("SUMALL").ShowAllData
    Else
    End If
    i need some changes in this code
    i want if i filtered range with some string for example "aam"
    i press this code the this one clear the filter mode from range,

    now i want i again press this code then this code do filter as it was before
    i mean it filter again string "aam"

    thank you
    Use Code-Tags for showing your code :
    Please mark your question Solved if there has been offered a solution that works fine for you
    If You like solutions provided by anyone, feel free to add reputation using STAR *

  2. #2
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,958

    Re: Unfilter data and then filter again

    Check out link...
    https://www.mrexcel.com/forum/excel-...ter-state.html
    Good Luck...
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
    Also....Add a comment if you like!!!!
    And remember...Mark Thread as Solved...
    Excel Forum Rocks!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Filter Colored Cells, Autosum, Unfilter and keep results.
    By TrueFangz in forum Excel General
    Replies: 2
    Last Post: 08-10-2015, 12:36 PM
  2. Excel VBA - Filter/Unfilter After Deleting Data with Last Row and Last Column
    By jdmurphy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-23-2014, 12:34 PM
  3. [SOLVED] Filter Table as i type in textbox1 but when erasing the text filter should be unfilter
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-17-2014, 09:08 AM
  4. [SOLVED] Need: filter, paste info to new sheet, rename sheet, unfilter, hide column, filter next
    By esmithqg in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-18-2012, 04:49 PM
  5. Replies: 3
    Last Post: 03-15-2012, 10:01 PM
  6. VBA to actvate Unfilter after Auto Filter
    By Zimbo in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-19-2008, 02:10 AM

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