+ Reply to Thread
Results 1 to 5 of 5

Macro to delete filtered values. Criteria = Sheet name

  1. #1
    Forum Contributor
    Join Date
    12-18-2011
    Location
    long island
    MS-Off Ver
    365
    Posts
    236

    Macro to delete filtered values. Criteria = Sheet name

    Hello,

    I have the below code
    Please Login or Register  to view this content.
    Which simply sorts items using the sheet name. I'd like to go further and have the macro delete every item that DOES NOT show in the filter. Namely, everything else.

  2. #2
    Valued Forum Contributor
    Join Date
    06-23-2021
    Location
    Romania
    MS-Off Ver
    2021, 365 v 2208
    Posts
    722

    Re: Macro to delete filtered values. Criteria = Sheet name

    Did you consider to change criteria to <>ActiveSheet.Name and then delete entire rows for visible cells?
    Diana Tanase


    If the solutions offered helped you to solve your problem, then mark the thread as SOLVED (thread tools in the top menu) and you can click on * to add reputation to those who helped you, as a way to say thank you !

  3. #3
    Valued Forum Contributor
    Join Date
    06-23-2021
    Location
    Romania
    MS-Off Ver
    2021, 365 v 2208
    Posts
    722

    Re: Macro to delete filtered values. Criteria = Sheet name

    HTML Code: 
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    12-18-2011
    Location
    long island
    MS-Off Ver
    365
    Posts
    236

    Re: Macro to delete filtered values. Criteria = Sheet name

    Thank worked
    Thanks!

  5. #5
    Valued Forum Contributor
    Join Date
    04-01-2015
    Location
    The Netherlands
    MS-Off Ver
    2003/2007/2010/2016/office 365
    Posts
    880

    Re: Macro to delete filtered values. Criteria = Sheet name

    This seems more logical to me if a table is used anyway.
    Please Login or Register  to view this content.
    Messages have been translated from Dutch to English by means of google translate.

+ 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] Delete Visibile Rows on Filtered Criteria
    By Ratso in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-15-2020, 03:49 PM
  2. [SOLVED] Delete rows based on filtered criteria
    By Ramzes in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-08-2017, 07:01 AM
  3. Macro to total values based on vendor criteria, delete rows & continue on
    By Tomtherom in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-16-2015, 04:52 PM
  4. [SOLVED] Macro to count unique values in a column with pop up message box - sheet will be filtered
    By excel151515 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-27-2014, 10:53 AM
  5. Replies: 3
    Last Post: 02-22-2013, 11:28 AM
  6. Delete criteria when filtered
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-25-2011, 09:31 AM
  7. MAcro to Delete Values in sheet
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-26-2007, 02:58 PM

Tags for this Thread

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