+ Reply to Thread
Results 1 to 4 of 4

Delete entire rows in column

  1. #1
    Forum Contributor
    Join Date
    06-01-2015
    Location
    Chennai,India
    MS-Off Ver
    Microsoft Office 2021
    Posts
    146

    Delete entire rows in column

    Hi all,

    It is simple task to delete entire row in a sheet using VBA but i have different scenario wherein i am not getting the expected result. Please assist me since i am looking into it for last 2 hours to resolve this issue. Refer attached file and below points as well for more details.

    1. My header is located from Row 12 to 13 wherein i need delete all the rows before rows 12.

    2 . My second challenge is i am not able to delete the rows after the Used range i.e. from Row 15 to till end also note, tomorrow i may get the details from Row 14 to Row 16 in that scenario i need to delete the rows from Row 17.

    3 . For clear picture, i have highlighted the rows in Orange which i need to delete while running the macro.

    Please assist me.
    Attached Files Attached Files
    Last edited by Revathi kannan; 08-02-2020 at 07:51 AM.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Delete entire rows in column

    Your profile indicates you are using XL 2007. You have been a part of this group since 2015. Are you still using 2007 or have you upgraded? If you are using a later version, please indicate this by changing your profile to your current version. This will allow helpers to use the latest functions within excel.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Contributor
    Join Date
    06-01-2015
    Location
    Chennai,India
    MS-Off Ver
    Microsoft Office 2021
    Posts
    146

    Re: Delete entire rows in column

    Thank you. Updated my profile.. i am using 2013 right now..
    Last edited by Revathi kannan; 08-02-2020 at 09:07 AM.

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Delete entire rows in column

    Using Power Query, it is a few simple steps. You can add PQ to your version of Excel at the MS web site. Here is the Mcode

    Please Login or Register  to view this content.
    Review PQ
    In the attached file
    Click on any cell in the new table
    On the Data Tab, click on Queries & Connections
    In the right window, double click to open Query
    Review PQ steps

    M-code basics:
    - "let" is the start of a query
    - "in" is the closing of a query
    - each transformation step sits in between those 2 lines
    - each step line is ended by a comma, except the last one
    - "Source" is always the first step (Source Data)
    - After "in" you have the last step referenced
    Attached Files Attached Files

+ 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] Delete All entire Rows in which Column A Cell value Not Starts with 1 or 2
    By abhinavbinkar in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-27-2018, 02:12 AM
  2. [SOLVED] Delete entire rows if cells in column D contain TX
    By oneyejack77 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-12-2017, 03:12 PM
  3. Macro to delete entire rows if column d equals 2925-6 & abc
    By Triscia in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-14-2015, 07:50 AM
  4. [SOLVED] Delete entire Rows if Column value is unique OR Duplicate is less than three
    By analystbank in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-02-2014, 12:09 PM
  5. [SOLVED] Select column C and delete blank entire rows Till C300
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-04-2014, 08:55 AM
  6. How to efficiently delete entire rows based on duplicates in one column
    By HughManatee in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-16-2013, 06:53 PM
  7. [SOLVED] Delete entire rows where there is a blank in column A
    By Chris Hankin in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-11-2006, 05:00 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