+ Reply to Thread
Results 1 to 5 of 5

Macro to find Text and clear certain rows to the right of this

  1. #1
    Forum Contributor
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2016
    Posts
    1,633

    Macro to find Text and clear certain rows to the right of this

    I have tried to right code to find the text containing "Consignment" on Col D


    Once found, I need the data in the following columns in the same row as "consignment" to be cleared (have highlighted the cells to be cleared in yellow)

    These are Col's G, K, H & U


    it would be appreciated if someone could assist me

    My code is


    Please Login or Register  to view this content.

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,540

    Re: Macro to find Text and clear certain rows to the right of this

    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    18,991

    Re: Macro to find Text and clear certain rows to the right of this

    Change
    Please Login or Register  to view this content.
    to
    Please Login or Register  to view this content.
    Last edited by jindon; 12-21-2020 at 11:16 PM. Reason: a typo

  4. #4
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    1,779

    Re: Macro to find Text and clear certain rows to the right of this

    Try

    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2016
    Posts
    1,633

    Re: Macro to find Text and clear certain rows to the right of this

    Many thanks for the help

+ 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] Find last row that contains data and clear/delete all blank rows after it
    By tkbuc in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-01-2019, 12:51 AM
  2. [SOLVED] Macro to find Text Total in Row 1 and clear entire Col
    By Howardc1001 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-29-2019, 12:05 AM
  3. [SOLVED] Find and Clear certain text from cells
    By xBxW in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-04-2018, 12:49 AM
  4. Macro to find text and delete active row and rows above/below
    By mrsvanessen in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-02-2013, 03:35 PM
  5. Replies: 4
    Last Post: 09-18-2012, 10:54 AM
  6. macro to find first blank cell in rows and insert text
    By jlm13 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-21-2010, 06:27 PM
  7. Find Text Clear Next Row
    By wburbage in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-24-2007, 08:14 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