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, 05:08 AM #1
    jeff
    jeff is offline
    Senior Member
    Join Date
    Jul 2013
    Posts
    102
    Rep Power
    13
    The code transfers tasks completed to Archive sheet but it also comes up with a Error - Runtime Error 1004 No Cells Were Found
    This line of code -
    .SpecialCells(xlCellTypeBlanks).EntireRow.Delete
    Any thoughts
    Thanks
    Jeff
    Attached Files Attached Files
    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