Results 1 to 7 of 7

Thread: Delete Rows Based on Conditions

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Junior Member
    Join Date
    Feb 2013
    Posts
    3
    Rep Power
    0
    I tried it and it seemed to work good, except I noticed A1 started with "Printed" and was still there. I also noticed a couple of other things, so I added them:

    onst SearchKeysBeginsWith As String = "Fill List,Printed,DOB:,(et,Aller,Generic,Rx #" '<< add more words separated by comma

    When I ran it again, it stopped. The Spreadsheet was Filtered, with only Row 1 showing, and the rest empty. I ran Debugger which highlighted this line: c.EntireRow.Delete

    Maybe I shouldn't have run it twice?

    Any ideas?
    Thanks
    AbiG

  2. #2
    Junior Member
    Join Date
    Feb 2013
    Posts
    3
    Rep Power
    0
    OK--I pasted it into another worksheet and ran again. It did fine. Maybe it was running it twice that did it. So, I won't run it twice.

    In any case--it works great! Thanks a lot!
    AbiG

Similar Threads

  1. Replies: 4
    Last Post: 03-22-2013, 01:47 PM
  2. Delete Rows
    By ayazgreat in forum Excel Help
    Replies: 2
    Last Post: 12-13-2012, 11:48 AM
  3. Replies: 1
    Last Post: 12-04-2012, 08:56 AM
  4. Delete unwanted rows & column
    By sanjeevi888 in forum Excel Help
    Replies: 1
    Last Post: 09-30-2012, 08:52 AM
  5. Delete Empty Rows
    By Rasm in forum Excel Help
    Replies: 4
    Last Post: 04-28-2011, 02:13 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •