Results 1 to 5 of 5

Thread: in VBA if the given string is found then delete everything between two newlines where the string appears.

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 09-16-2022, 01:02 AM #1
    santa1234
    santa1234 is offline
    Junior Member
    Join Date
    Apr 2022
    Posts
    10
    Rep Power
    0

    in VBA if the given string is found then delete everything between two newlines where the string appears.

    "Looking for help in VBA"

    if the given string is found in any excel cell then delete everything between two newlines where the string appears.

    Moderator Notice:
    The OP sent me this PM. It might be related to this question? It might be an attempt to reply to some of my recent comments to him regarding his posting style.
    (It continues to be difficult to communicete or get through to this guy, :( )

    Quote Originally Posted by santa1234
    How can I delete sentences with a specific keyword in excel cells in all sheets?
    Hello Sir,
    How can I delete sentences with a specific keyword in excel cells in all sheets?
    I searched a lot on google but could not find a solution.
    Thanks.



    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    https://www.youtube.com/watch?v=2oT4qrHmDMY&lc=UgwviLabd7r_3KpP6wh4AaABAg. 9h5lFRmix1R9h78GftO_iE
    https://www.youtube.com/watch?v=2oT4qrHmDMY&lc=UgyG714V_k7odQMrTz14AaABAg. 9h740K6COOA9h77HSGDH4A
    https://www.youtube.com/watch?v=2oT4qrHmDMY&lc=UgyG714V_k7odQMrTz14AaABAg. 9h740K6COOA9h76fafzcEJ
    https://www.youtube.com/watch?v=2oT4qrHmDMY&lc=UgyG714V_k7odQMrTz14AaABAg. 9h740K6COOA9h759YIjlaG
    https://www.youtube.com/watch?v=2oT4qrHmDMY&lc=UgyG714V_k7odQMrTz14AaABAg. 9h740K6COOA9h74pjGcbEq
    https://www.youtube.com/watch?v=2oT4qrHmDMY&lc=UgyG714V_k7odQMrTz14AaABAg
    https://www.youtube.com/watch?v=2oT4qrHmDMY&lc=UgzJJUDVv2Mb6YGkPYh4AaABAg. 9h5uPRbWIZl9h7165DZdjg
    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    Attached Files Attached Files
    Last edited by DocAElstein; 07-10-2023 at 07:09 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. "What’s in a String"- VBA break down Loop through character contents of a string
    By DocAElstein in forum Excel and VBA Tips and Tricks
    Replies: 26
    Last Post: 07-09-2023, 04:57 PM
  2. PQ - Extract initial letters string from longer string with different length
    By sandy666 in forum ETL PQ Tips and Tricks
    Replies: 0
    Last Post: 07-08-2020, 04:29 PM
  3. Delete entire column if a specific string is found in a row.
    By Tony_Caliente in forum Excel Help
    Replies: 1
    Last Post: 11-16-2018, 01:11 PM
  4. Looping Through String Using Excel VBA!
    By Jdean in forum Excel Help
    Replies: 15
    Last Post: 09-12-2014, 09:24 AM
  5. VBA Using MID Function To Replace Portion Of A String
    By Transformer in forum Tips, Tricks & Downloads (No Questions)
    Replies: 1
    Last Post: 05-30-2013, 08:22 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