+ Reply to Thread
Results 1 to 3 of 3

Excel 2007 : Deleting Rows Macro

  1. #1
    Registered User
    Join Date
    03-08-2010
    Location
    New York, US
    MS-Off Ver
    Excel 2010
    Posts
    25

    Deleting Rows Macro

    Hi All:

    I have a sheet with 120,000+ rows of data. I need excel to delete an entire row if it finds a zero in column D. I found some macros online but they keep crashing. I'm assuming it's because my sheet is a monster. Do you know of a macro that can help me? Thanks,

    Mike

  2. #2
    Registered User
    Join Date
    03-08-2010
    Location
    New York, US
    MS-Off Ver
    Excel 2010
    Posts
    25

    Re: Deleting Rows Macro

    OMG....i've been looking at numbers too long.....I can simply apply filter for zeros and delete....................................

  3. #3
    Registered User
    Join Date
    02-16-2010
    Location
    Centrl Florida
    MS-Off Ver
    Excel 2007
    Posts
    28

    Re: Deleting Rows Macro

    Quote Originally Posted by Mike74 View Post
    OMG....i've been looking at numbers too long.....I can simply apply filter for zeros and delete....................................
    Good Job... Good Job... http://www.youtube.com/watch?v=sAhReoyuJ5M

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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