+ Reply to Thread
Results 1 to 6 of 6

Delete "blank" rows in table

  1. #1
    Forum Contributor
    Join Date
    02-26-2015
    Location
    Canada
    MS-Off Ver
    2013
    Posts
    248

    Delete "blank" rows in table

    After running a code, I end up with two columns in a table.
    In col D there are blank cells.
    I need to delete the rows with the blank cells in D via code I can incorporate into the existing macro.
    Even though the cells look blank they are obviously not and unless I clear the cells manually first, I can't delete the blank cells/rows
    Please and thank you
    Attached Files Attached Files

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

    Re: Delete "blank" rows in table

    How about...

    Please Login or Register  to view this content.
    HTH
    Regards, Jeff

  3. #3
    Forum Contributor
    Join Date
    02-26-2015
    Location
    Canada
    MS-Off Ver
    2013
    Posts
    248

    Re: Delete "blank" rows in table

    Hi, Jeffrey

    Thanks for "popping in".
    When I run as a separate WS, like attached, works great.
    But the two columns are actually in another WS, kinda like helper columns.
    When I run it in the "complete" WS, it gets hung up at the ...Offset line

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

    Re: Delete "blank" rows in table

    Hi BDD2015,

    As you say, when run with the attached workbook it works well, but now that things have changed, please attach the sample workbook so we can get the right workup.

  5. #5
    Forum Contributor
    Join Date
    02-26-2015
    Location
    Canada
    MS-Off Ver
    2013
    Posts
    248

    Re: Delete "blank" rows in table

    Hi, again Jeffrey

    Actually nothing has "changed." The two columns I submitted always were the "helper columns" attached to a larger WB. Unfortunately, I still suck at explanations. I always intend to ask for the simplest thing and find a way to adjust it, if necessary, to fit my "bigger picture." Just as I have done with yours. It works great on what I gave you but not so much when I put it in its new home. So, I modified the dwelling, gave it its own home, used your formula, put them both back together into a multi-family dwelling and voila. Nothing would have worked though without your formula because I really suck at them. So, thank you Jeffrey. And next time I have an ask, I will be more clear and provide better samples.

  6. #6
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,179

    Re: Delete "blank" rows in table

    Hi BDD2015,

    That's great news. So glad you were able to work it out and now you have something to move your project further down the road.

    You are very welcome and let us know any of your future needs.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA Updates Pivot Table by cell contents, i want to show "blank" instead of "all"
    By mattinwpg in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-15-2017, 10:58 PM
  2. [SOLVED] Delete Rows if a cell does not equal "Finished" or "Complete"
    By Justair07 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 09-27-2013, 12:40 PM
  3. Stop copying data when it hits "(Blank)" rows in pivot table
    By ewong in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-18-2012, 07:15 PM
  4. [SOLVED] Delete the Rows If it is Blank cell below Table header "Status"
    By eltonlaw in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-19-2012, 05:55 AM
  5. Delete rows in the result of formulas "OK" n column "J"
    By marreco in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-29-2012, 10:08 AM
  6. macro to delete row containing "private" then rows beneath upto blank row
    By Wagstaff in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-24-2010, 01:14 AM
  7. Replies: 1
    Last Post: 07-05-2005, 10:06 AM

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