+ Reply to Thread
Results 1 to 5 of 5

Deleting completely blank rows ?

  1. #1
    Registered User
    Join Date
    06-16-2010
    Location
    Sydney
    MS-Off Ver
    Excel 2007
    Posts
    8

    Deleting completely blank rows ?

    I have a problem that may have a very easy solution....but buggered if I can find it (even after searching on this forum and trying to use various VBE routines that I found)

    I have a spreadsheet that is thousands of rows long which describes a series of instructions.

    In particular, I am only interested in rows that say "Queue to" and the associated value which will be in the range 1-250 (this will be on the very next Row, but not the same Column))

    I have eliminated most of the unwanted instructions by using "Find and Replace" and now have a series of blank Rows.

    Column A may have data
    Column B may have data

    I only want to delete the Rows where there is no data in either of the columns

    Am I missing something easy ?
    Last edited by hg34; 08-16-2010 at 08:43 PM.

  2. #2
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    Re: Deleting completely blank rows ?

    Hi,

    if it is a one time job,you can Autofilter your list on blanks in col A, then delete the resulting rows, and do te same ffor blanks in col B

  3. #3
    Registered User
    Join Date
    06-16-2010
    Location
    Sydney
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Deleting completely blank rows ?

    Yes....it is a one time job.

    If I filter Column A on blanks and then delete the resulting Rows....won't that ignore the fact that there was data in Column B ?

    example below I want to find and delete Rows 5 and 8 (no data in either column) :
    ........Column A Column B
    1......Queue to
    2 .......................2
    3......Queue to
    4 .......................98
    5
    6......Queue to
    7 ........................3
    8

    I have added the .......to put the values in Columns in this thread (obviously they are not present in the spreadsheet)
    Last edited by hg34; 08-16-2010 at 02:52 AM.

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

    Re: Deleting completely blank rows ?

    filter by blanks column a then with that filter still on filter blanks col b
    "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

  5. #5
    Registered User
    Join Date
    06-16-2010
    Location
    Sydney
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Deleting completely blank rows ?

    Thanks Guys....your suggestion on the Filters helped indirectly.

    Where I had previously used "Find and Replace" to create the problematic blank rows, I utilised your Filter suggestion to delete those rows in the first place from the original spreadsheet rather than creating the thousands of blank rows.

    Much easier now to see my specific rows

+ 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