Results 1 to 5 of 5

VBA to delete rows hidden by filters - broken

Threaded View

  1. #1
    Registered User
    Join Date
    01-12-2020
    Location
    California
    MS-Off Ver
    2016
    Posts
    53

    Unhappy VBA to delete rows hidden by filters - broken

    Hello,

    I have a large table with several slicers that filter the document based on entries in different columns. I am looking for a VBA to delete all rows hidden by slicers. Please take a look at the attached spreadsheet; the VBA linked to button on Sheet1 is supposed to delete my hidden rows (3, 4, 6). However, it returns an error in line 22.
    This post is edited due to my non-compliance to the board rules of cross-posting for which I apologize for: the cross post can be found here. I am looking for a VBA to delete in bulk by range and now row by row due to it being very slow on a large table.
    Your help is greatly appreciated.
    Last edited by aldenes; 10-23-2020 at 09:36 PM. Reason: Original not compliant with forum rules

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Delete rows using filters
    By robert26 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-07-2019, 05:53 PM
  2. Replies: 10
    Last Post: 06-07-2018, 04:16 PM
  3. Replies: 8
    Last Post: 04-25-2017, 03:46 AM
  4. [SOLVED] Use of Three filters and Delete Rows using VBA Code in Excel
    By gbloemke in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-01-2013, 03:27 PM
  5. Replies: 4
    Last Post: 06-11-2010, 03:29 PM
  6. filters with hidden rows issue
    By smite0hb in forum Excel General
    Replies: 1
    Last Post: 05-05-2010, 03:22 PM
  7. Replies: 4
    Last Post: 05-19-2008, 05:13 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