+ Reply to Thread
Results 1 to 4 of 4

Remove all rows with cells in certain column starting with letter "X" efficiently

  1. 04-29-2015, 09:31 AM #1
    nn90 is offline
    Registered User
    Join Date
    11-12-2014
    Location
    usa
    MS-Off Ver
    2007
    Posts
    5

    Remove all rows with cells in certain column starting with letter "X" efficiently

    Hi all
    I am trying to remove all rows with cells in certain column starting with letter "X" efficiently. I have written a code to do it row by row and it takes a lot of time.
    Any ideas?
    Thanks
    Reply With QuoteRegister To Reply
  2. 04-29-2015, 09:44 AM #2
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Remove all rows with cells in certain column starting with letter "X" efficiently

    Does this help?

    Please Login or Register  to view this content.
    Assumes Column is A.
    Reply With QuoteRegister To Reply
  3. 04-29-2015, 09:53 AM #3
    nn90 is offline
    Registered User
    Join Date
    11-12-2014
    Location
    usa
    MS-Off Ver
    2007
    Posts
    5

    Re: Remove all rows with cells in certain column starting with letter "X" efficiently

    Worked great John.
    Awesome.
    Many thanks
    Reply With QuoteRegister To Reply
  4. 04-29-2015, 10:12 AM #4
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Remove all rows with cells in certain column starting with letter "X" efficiently

    You're welcome. Glad to help out and thanks for the feedback.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. "Add Row" and "Remove Row" Buttons... adding rows with formulas down filled
    By excelatnothing in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-15-2015, 02:44 AM
  2. [SOLVED] List only cells in a column with text (remove "blanks")
    By arobacker in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-31-2012, 10:09 PM
  3. How to filter the value starting with "EXT" in multiple rows of UserGroupAccess Colum
    By ravi3cha in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-02-2010, 02:49 PM
  4. Search all rows on Sheet1 for cells in Column "C" that contain "PD" and if found cut
    By STEVEB in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-05-2008, 04:51 PM
  5. Changing first letter to caps, letters after "-" and "/", and rest to small letter.
    By rhexis07 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-17-2008, 08:03 PM

Tags for this Thread

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


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1