+ Reply to Thread
Results 1 to 5 of 5

2003 Delete rows with specific value in column C

  1. #1
    Registered User
    Join Date
    10-08-2008
    Location
    Hallandale
    Posts
    44

    2003 Delete rows with specific value in column C

    I need a code that will go thru column C and delete the whole row if cell value is 78315,
    Also it needs to shift the the rows up so there is no empty rows wheneverything is done done
    I used some codes but they take forever to go thru whole sheet, so please the fast and simple code would be appreciated.
    Thanks
    Last edited by koklok; 04-15-2009 at 12:12 PM.

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: 2003 Delete rows with specific value in column C

    Why don't you just use AutoFilter, sort and then block delete?
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: 2003 Delete rows with specific value in column C

    try a non vba method
    insert a new column or pick one out of range
    and in cell 1 of that column put
    =if(c1=78315,"found",row())
    then drag down to as many rows in column c
    now select the whole sheet
    and sort by the new column
    all the rows with "found" will be at the bottom
    the others will have all moved up but still be in their original order
    select all the rows with "found" in and delete in one go.
    then delete added column
    then again i just read above and thought yes why not use use auto filter?
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  4. #4
    Forum Contributor
    Join Date
    02-27-2008
    Posts
    764

    Re: 2003 Delete rows with specific value in column C

    Hi
    try this macro.
    Ravi
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    10-08-2008
    Location
    Hallandale
    Posts
    44

    Re: 2003 Delete rows with specific value in column C

    Thanks ravishankar

+ 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