Results 1 to 6 of 6

Delete "blank" rows in table

Threaded View

  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

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