+ Reply to Thread
Results 1 to 4 of 4

Macro to Delete Blank rows in Col A above Text "Code"

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

    Macro to Delete Blank rows in Col A above Text "Code"

    I have written code to delete blank rows in Col A

    I would like this amended to only delete blank rows above text "Code" in Col A


    Please Login or Register  to view this content.

    Your assistance in this regard is most appreciated

  2. #2
    Valued Forum Contributor
    Join Date
    11-04-2018
    Location
    Denpasar
    MS-Off Ver
    Excel 2010
    Posts
    777

    Re: Macro to Delete Blank rows in Col A above Text "Code"

    If I understand you correctly....
    Please Login or Register  to view this content.
    The macro above will delete cell A1 to A3,
    and shift all the rows below A3 starts from cell A1.

    In your case,
    the text "Code" becomes in cell A1
    the number 98715 becomes in cell A2
    Last edited by karmapala; 09-29-2021 at 10:21 PM.

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

    Re: Macro to Delete Blank rows in Col A above Text "Code"

    Quote Originally Posted by Howardc1001 View Post
    only delete blank rows above text "Code" in Col A
    Please Login or Register  to view this content.

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

    Re: Macro to Delete Blank rows in Col A above Text "Code"

    Thanks for the help

    Jindon's code is more suitable for my requirement

+ 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] How to code delete all value of "Blank" this code is working but 1 Row at a time.
    By Chandria in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-30-2019, 01:15 AM
  2. [SOLVED] Delete "blank" rows in table
    By BDD2015 in forum Excel General
    Replies: 5
    Last Post: 12-17-2017, 09:16 PM
  3. [SOLVED] Code that copies row of data to another sheet based on text "Complete"/"Delete"
    By Dremzy in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 04-20-2014, 05:51 PM
  4. Replies: 2
    Last Post: 04-20-2014, 11:18 AM
  5. [SOLVED] Delete the Rows If it is Blank cell below Table header "Status"
    By eltonlaw in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-19-2012, 05:55 AM
  6. macro to delete row containing "private" then rows beneath upto blank row
    By Wagstaff in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-24-2010, 01:14 AM
  7. Replies: 1
    Last Post: 07-05-2005, 10:06 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