Results 1 to 6 of 6

Thread: How To Remove or Delete Blank Or Empty Rows After Data Is Transferred

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. 07-11-2013, 07:25 AM #1
    Admin
    Admin is offline
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10
    Hi

    Add the following line
    Code:
    on error resume next
    before the line

    Code:
    .SpecialCells(xlCellTypeBlanks).EntireRow.Delete
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)
    Reply With Quote Reply With Quote
  2. 07-11-2013, 07:31 AM #2
    jeff
    jeff is offline
    Senior Member
    Join Date
    Jul 2013
    Posts
    102
    Rep Power
    13
    Thanks Admin
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Find All Empty Blank Cells Or KeyWord In A Column
    By william516 in forum Excel Help
    Replies: 9
    Last Post: 06-25-2013, 05:20 PM
  2. Delete All Empty Cells From Range Using VBA / Remove Blank Cells Using Formula
    By mahmoud-lee in forum Excel Help
    Replies: 13
    Last Post: 06-10-2013, 09:05 AM
  3. Delete Remove Rows By Criteria VBA Excel
    By marreco in forum Excel Help
    Replies: 5
    Last Post: 12-20-2012, 05:56 PM
  4. Remove Entire Row of Blank Cells in Column, Autofilter non-empty non-blank cells
    By sanmaya in forum Excel Help
    Replies: 2
    Last Post: 09-24-2012, 11:19 PM
  5. Delete Empty Rows
    By Rasm in forum Excel Help
    Replies: 4
    Last Post: 04-28-2011, 02:13 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
  •  

Forum Rules