+ Reply to Thread
Results 1 to 4 of 4

Spreadsheet cleanup - Delete hidden rows

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

    Spreadsheet cleanup - Delete hidden rows

    I have the follow lines of code:
    HTML Code: 
    I'm trying to impose certain filters on certain sheets (depending on the sheet name) and then delete the hidden rows, as that information is not important and only making my workbook needlessly larger. However, that last if loop (wks.rows.hidden = true) is not doing anything. I am not receiving any errors, but the macro is not deleting the hidden rows.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Spreadsheet cleanup - Delete hidden rows

    Is your forum profile up-to-date? Are you still using Excel 2013?
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

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

    Re: Spreadsheet cleanup - Delete hidden rows

    Change the filter to display the rows you want to delete and delete 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 !

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Spreadsheet cleanup - Delete hidden rows

    Thanks for the rep and marking this as solved.

+ 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 hidden rows VBA is very slow - Please help!
    By aldenes in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-19-2020, 02:11 PM
  2. [SOLVED] VBA to delete hidden (unfiltered) rows
    By benjhardie in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-27-2019, 03:04 PM
  3. Replies: 10
    Last Post: 06-07-2018, 04:16 PM
  4. Replies: 1
    Last Post: 04-08-2014, 02:50 AM
  5. Cleanup Spreadsheet
    By CNE5x in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-31-2012, 05:05 PM
  6. Replies: 4
    Last Post: 06-11-2010, 03:29 PM
  7. Delete Hidden Rows
    By Makeda in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 05-18-2005, 03:03 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