+ Reply to Thread
Results 1 to 3 of 3

Macro to Delete Delete headings and 9 rows above from row 15 onwards

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

    Macro to Delete Delete headings and 9 rows above from row 15 onwards

    I have headings in Col A and want code to delete the same headings that appears in Col A that contain "Bill From" and 9 rows above this

    I have highlighted the rows to be deleted for ease of refrence

    My code below is not deleting any rows


    Please Login or Register  to view this content.

    Your assistance in resolving this is most appreciated

  2. #2
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    4,506

    Re: Macro to Delete Delete headings and 9 rows above from row 15 onwards

    If your data range is not too large, looping should be OK.
    Please Login or Register  to view this content.

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

    Re: Macro to Delete Delete headings and 9 rows above from row 15 onwards

    Thanks for the help. Code works perfectly

+ 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] Macro to delete rows from duplicated header onwards
    By Howardc1001 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-28-2021, 11:38 PM
  2. [SOLVED] Macro to delete Duplicate DHeadings from Row3 onwards and 4 rows below this
    By Howardc1001 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-14-2020, 06:22 AM
  3. [SOLVED] Macro to delete rows containing duplicate headings from row 2 onwards
    By Howardc1001 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-25-2020, 11:17 PM
  4. [SOLVED] Macro to delete Duplicate headings on Workbooks in a folder
    By Howardc1001 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 05-02-2019, 07:38 AM
  5. Todays' Date onwards delete data
    By anildaravastu in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-17-2014, 01:24 PM
  6. Delete Filtered Rows - Leave Headings
    By hutch@edge.net in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-26-2012, 02:10 AM
  7. Macro to delete certain columns and delete rows based on time in another column
    By beepbeep27 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-12-2012, 11:47 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