+ Reply to Thread
Results 1 to 6 of 6

Delete Blank Rows-Blank Row between my data range

  1. #1
    Forum Contributor Bob@Sun's Avatar
    Join Date
    09-03-2009
    Location
    Montuak, Usa
    MS-Off Ver
    Excel 2007
    Posts
    438

    Delete Blank Rows-Blank Row between my data range

    Hello,

    Can you please help me with a code that will chack if there is Blank Row between my data range and if some to delete it?

    My data resides in Columns A true K and if even one cell has data then asume the row is non blank.

    I have found some codes but they search if specific column is Empty and I need to check if the whole row is empty.

    Any ideas?

    Thanks!
    Last edited by Bob@Sun; 02-27-2010 at 02:53 PM.

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    re: Delete Blank Rows-Blank Row between my data range

    Bob,

    Is this something you could work with?

    http://www.ozgrid.com/VBA/VBACode.htm

  3. #3
    Forum Contributor Bob@Sun's Avatar
    Join Date
    09-03-2009
    Location
    Montuak, Usa
    MS-Off Ver
    Excel 2007
    Posts
    438

    re: Delete Blank Rows-Blank Row between my data range

    That is Exaclty what I have found, but is not doing the job. I don't know why.

  4. #4
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    re: Delete Blank Rows-Blank Row between my data range

    Bob,

    Something came up...got to run...back in 45 or so...

  5. #5
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    re: Delete Blank Rows-Blank Row between my data range

    Try this:
    Please Login or Register  to view this content.
    Entia non sunt multiplicanda sine necessitate

  6. #6
    Forum Contributor Bob@Sun's Avatar
    Join Date
    09-03-2009
    Location
    Montuak, Usa
    MS-Off Ver
    Excel 2007
    Posts
    438

    re: Delete Blank Rows-Blank Row between my data range

    Yes this is wokring Great!

    Thanks a lot.

+ 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