+ Reply to Thread
Results 1 to 2 of 2

Cleaning up excel sheet taking too long

  1. #1
    Registered User
    Join Date
    09-30-2010
    Location
    Canada
    MS-Off Ver
    Excel 2013
    Posts
    33

    Cleaning up excel sheet taking too long

    Hi All,

    I've got a massive excel sheet that I am trying to clean up by clearing out all rows that have a cell that contain either blank or a zero. I also need it to delete any row in that does not equal the number 3 in column "C".

    The sheet is about ~148,000 rows long and I have to do this with 60 different sheets.

    This is the code that I have written:
    Please Login or Register  to view this content.
    Now deleting the blank cells and the zeroes in columns "F" & "G" are no problem, it'll clear it up in a matter of seconds, but when it is trying to clean up column "C" it runs and runs and runs. Am I writing it incorrectly? Is there a more efficient way of doing this?

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Cleaning up excel sheet taking too long

    My VBA is weak at best, but could you not combine those with OR()?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. Excel Macro searching value in an array taking really long
    By realdemigod in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-17-2014, 12:16 PM
  2. Downloaded Excel file taking long time to open
    By Nanjunda in forum Excel General
    Replies: 1
    Last Post: 11-14-2013, 09:10 AM
  3. Excel taking too long to respond
    By jacob@thepenpoint in forum Excel General
    Replies: 2
    Last Post: 03-04-2011, 11:06 AM
  4. Excel (2003) array formula taking too long
    By Krazy Kasper in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-11-2008, 11:26 PM
  5. [SOLVED] Excel taking too long to open up
    By dkblee in forum Excel General
    Replies: 1
    Last Post: 03-26-2006, 06:35 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