+ Reply to Thread
Results 1 to 5 of 5

Delete rows without numbers (modify existing script)

  1. #1
    Forum Contributor
    Join Date
    02-24-2010
    Location
    BC, Canada
    MS-Off Ver
    Excel 2010
    Posts
    174

    Cool Delete rows without numbers (modify existing script)

    Hi,

    On this forum someone made the following script for me. Basically, it pops up a box and I enter a column letter and then it deletes every row (the entire row) where the value in that column is blank. What I need to do is modify it so that it deletes every row that is NOT a number. For example, if column A and B were the following:

    Name Rate
    John 66
    Jane 67
    Joe ----
    <-- this is actually a bunch of dashes in column B

    Name Rate
    Jeff 86


    Then after running the script and entering "b" it would end up with the following:

    John 66
    Jane 67
    Jeff 86



    Please Login or Register  to view this content.
    Thanks!!!

  2. #2
    Valued Forum Contributor
    Join Date
    09-21-2003
    Location
    British Columbia , Canada
    MS-Off Ver
    03,07,10,13
    Posts
    727

    Re: Delete rows without numbers (modify existing script)

    Since you want choice of type of cell to delete try this macro
    1) Select an entire column
    2) run macro
    3) select types of cells to delete when prompted


    Please Login or Register  to view this content.
    Last edited by nimrod; 04-13-2011 at 10:32 PM.

  3. #3
    Valued Forum Contributor
    Join Date
    09-21-2003
    Location
    British Columbia , Canada
    MS-Off Ver
    03,07,10,13
    Posts
    727

    Re: Delete rows without numbers (modify existing script)

    VERSION 2 ( Same instructions as last posting ... this one has the cancel button enabled)

    Please Login or Register  to view this content.

  4. #4
    Forum Contributor
    Join Date
    02-24-2010
    Location
    BC, Canada
    MS-Off Ver
    Excel 2010
    Posts
    174

    Re: Delete rows without numbers (modify existing script)

    Quote Originally Posted by nimrod View Post
    VERSION 2 ( Same instructions as last posting ... this one has the cancel button enabled)

    Please Login or Register  to view this content.
    Thanks for the reply!

    It doesn't seem to have the options that I am looking for. There is no option for "text" or for " all except number" or anything like that.

  5. #5
    Valued Forum Contributor
    Join Date
    09-21-2003
    Location
    British Columbia , Canada
    MS-Off Ver
    03,07,10,13
    Posts
    727

    Re: Delete rows without numbers (modify existing script)

    Please Login or Register  to view this content.
    Then you haven't looked at the solution very closely . For just text click the "Constants" radio buttun and then uncheck everything but "text".

+ 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