Deleting Filtered Rows - Speeding it up - Page 2

Thanks Thanks:  0
Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

Thread: Deleting Filtered Rows - Speeding it up

  1. #11
    New Member
    Join Date
    Sep 2017
    Posts
    29
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Deleting Filtered Rows - Speeding it up

     
    Hi All, Thank you for all your suggestions.
    Unfortunately none of these helped reduce the time this process takes.
    The workbook that took 26 mins must have had something else going on with it, the file itself took 10 min to open and another 10 to enable it for editing. The workbooks this macro is run on is received from a variety of sources, so not always clean.
    The code still takes 10 -11 mins to run on an ideal workbook with approx 1200 rows.
    I'm still open to any other suggestions.

  2. #12
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    5,011
    Post Thanks / Like
    Mentioned
    109 Post(s)
    Tagged
    4 Thread(s)

    Default Re: Deleting Filtered Rows - Speeding it up

    Do you have any conditional formatting?
    - Posting guidelines, forum rules and terms of use
    - Try searching for your answer first, see how
    - Read the FAQs
    - List of BB codes

    Running Office 2003 & 2013 on Win 7

  3. #13
    Board Regular igold's Avatar
    Join Date
    Jul 2014
    Location
    Delray Beach, FL, USA
    Posts
    1,846
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Deleting Filtered Rows - Speeding it up

    You may also have some phantom bloated ranges in the book. Do you know how to check for that. How big in terms of megabytes is the workbook.
    ​igold

    I'm a drinker with a coding problem...

    All code is written with Excel 2010 - Please test all code on a backup copy of your data.


  4. #14
    New Member
    Join Date
    Sep 2017
    Posts
    29
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Deleting Filtered Rows - Speeding it up

      
    I don't know how to check for phantom bloated ranges. The size of the work book is a time sheet, the size depends on how many ppl are listed, how many shifts, and how many days of the month are covered. They can range from 300k to 2MB.

    I did come up with a fix though....I have deleted this part of my code and increased "i" from 4 to 5 to read the extra row in a different section of my code...so simple. Apologies for wasting your time!

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com