+ Reply to Thread
Results 1 to 7 of 7

VB Code to delete rows with certain text

  1. #1
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,308

    VB Code to delete rows with certain text

    Hello:

    Please refer to attached file.
    I am trying to use below code to delete rows consisting of text "1,REG", "2,REG" and "Money,DT" in column B.
    But not sure why it would not work...
    Please help
    Please Login or Register  to view this content.




    Let me know if you have any questions.
    Thanks.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    02-19-2013
    Location
    India
    MS-Off Ver
    07/16
    Posts
    2,386

    Re: VB Code to delete rows with certain text

    you should have
    Please Login or Register  to view this content.
    instead of
    Please Login or Register  to view this content.
    same stands for 2,REG
    -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST

    More we learn about excel, more it shows us, how less we know about it.

    for chemistry
    https://www.youtube.com/c/chemistrybyshivaansh

  3. #3
    Forum Expert nigelog's Avatar
    Join Date
    12-14-2007
    Location
    Cork, Ireland
    MS-Off Ver
    excel 2016 64bit - Windows 10
    Posts
    2,074

    Re: VB Code to delete rows with certain text

    You have a space after the commas
    Please Login or Register  to view this content.

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham
    MS-Off Ver
    365
    Posts
    8,172

    Re: VB Code to delete rows with certain text

    How about
    Please Login or Register  to view this content.

  5. #5
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,308

    Re: VB Code to delete rows with certain text

    Hello Guys

    Works

    R

  6. #6
    Forum Expert
    Join Date
    02-19-2013
    Location
    India
    MS-Off Ver
    07/16
    Posts
    2,386

    Re: VB Code to delete rows with certain text

    you are welcome !

  7. #7
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham
    MS-Off Ver
    365
    Posts
    8,172

    Re: VB Code to delete rows with certain text

    You're welcome & thanks for the feedback

+ 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. [SOLVED] VB Code to delete rows with certain text
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-09-2018, 02:35 PM
  2. VBA code to delete rows if column V contains certain text
    By Declamatory in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-03-2016, 12:20 PM
  3. Changing code from deleting rows to cut/paste rows into another sheet and delete blank row
    By kmarshall6576 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-18-2013, 01:54 AM
  4. [SOLVED] Code to delete rows that do not contain certain text in a cell
    By rwgladwin in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-12-2012, 07:45 AM
  5. vba code to delete rows with string of text found
    By yankeekid86 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-14-2011, 07:08 PM
  6. vba code to delete rows with string of text found
    By yankeekid86 in forum Access Programming / VBA / Macros
    Replies: 0
    Last Post: 09-13-2011, 11:50 PM
  7. Code to delete rows based on status code in Column I
    By LemonTwist in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-26-2009, 07:01 PM

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