Results 1 to 7 of 7

VBA to search for specific string and delete range

Threaded View

chriskay VBA to search for specific... 06-03-2020, 09:20 AM
Fluff13 Re: VBA to search for... 06-03-2020, 09:26 AM
chriskay Re: VBA to search for... 06-03-2020, 09:36 AM
Fluff13 Re: VBA to search for... 06-03-2020, 09:48 AM
Marc L Hi ! Try this … 06-03-2020, 09:58 AM
Sintek Re: VBA to search for... 06-03-2020, 01:47 PM
Rick Rothstein Re: VBA to search for... 06-03-2020, 02:26 PM
  1. #1
    Registered User
    Join Date
    08-15-2014
    Location
    Denmark
    MS-Off Ver
    365 Pro
    Posts
    94

    VBA to search for specific string and delete range

    Hi all

    For the attached example sheet, I need some simple VBA to search for every time "Title 1" appears (EXCLUDING the first time), and delete the row + 5 rows down.

    Meaning that in the attached sheet, EntireRow.Delete applies to A29:A34, A71:A76, and so on. The placement of "Title 1" are variable from project to project, but they ALWAYS come in the same pattern of 6 rows :-)

    Things that should remain in the attached sheet should only be Range("1:6") and all the data numbers.

    I hope you guys are able to help :-) Thank you very much!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Search string for specific characters, then output characters that reflect range
    By jackmaca in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-19-2020, 09:13 AM
  2. [SOLVED] Script to Search for a specific String then return cell values above that String-3
    By owensjb2 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-01-2015, 01:50 PM
  3. [SOLVED] Script to Search for a specific String then return cell values above that String-2
    By owensjb2 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-01-2015, 01:00 PM
  4. [SOLVED] Script to Search for a specific String then return cell values above that String
    By owensjb2 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-01-2015, 11:28 AM
  5. Search A Range For Specific Text String
    By xybadog in forum Excel Formulas & Functions
    Replies: 29
    Last Post: 01-14-2015, 07:15 AM
  6. [SOLVED] Need to search for a specific string in Column A and delete values within the same row
    By hgeo24 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-27-2014, 04:56 PM
  7. Search for any Text String in specific range and copy + offset + move
    By FN2010 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 05-05-2010, 07:04 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