+ Reply to Thread
Results 1 to 9 of 9

Selecting a cells Containing specific Characters

  1. #1
    Registered User
    Join Date
    05-16-2015
    Location
    Europe
    MS-Off Ver
    2013
    Posts
    12

    Red face Selecting a cells Containing specific Characters

    Hello,

    Perhaps someone could help me, I was unable to find a macro to what i thought to be a common thing.

    I need an macro to select cells from a row, containing "WHI" and a small addition, delete the whole Row where the cell is located.


    Thank you for taking time. I appreciate it!

  2. #2
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    4,548

    Re: Selecting a cells Containing specific Characters

    See next code
    Please Login or Register  to view this content.
    - Battle without fear gives no glory - Just try

  3. #3
    Registered User
    Join Date
    05-16-2015
    Location
    Europe
    MS-Off Ver
    2013
    Posts
    12

    Re: Selecting a cells Containing specific Characters

    Quote Originally Posted by PCI View Post
    See next code
    Please Login or Register  to view this content.
    Hey, thanks for the reply, it works. But after running the macro it deletes only 1 row, after running again it deletes the 2 row and so on.

  4. #4
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    4,548

    Re: Selecting a cells Containing specific Characters

    OK

    Here another one
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    05-16-2015
    Location
    Europe
    MS-Off Ver
    2013
    Posts
    12

    Re: Selecting a cells Containing specific Characters

    Quote Originally Posted by PCI View Post
    OK

    Here another one
    Please Login or Register  to view this content.

    It does the job.
    MY table is 20 000 rows big. And it takes lot of time for for the macro to accomplish the task. It seems like it is searching for cells in the whole sheets. I was trying to lock it to range B:B but could make it work.

  6. #6
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    4,548

    Re: Selecting a cells Containing specific Characters

    It searching in the complete used range.
    Is the text to search only in column "B" ??

  7. #7
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    4,548

    Re: Selecting a cells Containing specific Characters

    For text to search only in column "B", used next code
    Please Login or Register  to view this content.

  8. #8
    Registered User
    Join Date
    05-16-2015
    Location
    Europe
    MS-Off Ver
    2013
    Posts
    12

    Re: Selecting a cells Containing specific Characters

    Quote Originally Posted by PCI View Post
    For text to search only in column "B", used next code
    Please Login or Register  to view this content.
    Thank you !!!

  9. #9
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    4,548

    Re: Selecting a cells Containing specific Characters

    You 're welcome

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Deleting specific characters in cells
    By zforzani in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-20-2013, 12:25 PM
  2. [SOLVED] Call a specific macro by selecting different cells
    By ska87RA in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-05-2013, 09:14 AM
  3. Selecting specific cells
    By arambo in forum Excel General
    Replies: 5
    Last Post: 07-07-2010, 01:03 PM
  4. selecting specific cells from a matrix
    By sbcs in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-20-2009, 01:23 PM
  5. Auto-selecting of cells to match a specific value
    By yannhk in forum Excel General
    Replies: 1
    Last Post: 09-08-2009, 03:46 PM
  6. Selecting cells with specific conditions
    By Azheid in forum Excel General
    Replies: 5
    Last Post: 07-10-2008, 10:07 AM
  7. Selecting Specific Cells
    By maimal in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-21-2008, 01:53 PM
  8. [SOLVED] find cells that contain specific characters
    By mshornet in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-23-2005, 10:10 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