+ Reply to Thread
Results 1 to 4 of 4

VB Code to delete Blank Rows

  1. #1
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,348

    VB Code to delete Blank Rows

    Hello:

    Please refer to attached file.
    I am using below code to delete rows in Sheet3 with no data in column A.
    Not sure why does it not work.
    Please help


    Please Login or Register  to view this content.
    Let me know if you have any questions.
    Thanks.
    Attached Files Attached Files

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    31,882

    Re: VB Code to delete Blank Rows

    You'd need to use For i = lRow To 2 Step -1 in the loop
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,348

    Re: VB Code to delete Blank Rows

    Hello

    Thanks TMS.

    Below code works great thanks

    Please Login or Register  to view this content.
    Riz

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    31,882

    Re: VB Code to delete Blank Rows

    You're welcome. Thanks for the rep.

+ 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 Blank Rows Code If No Parts
    By fredfarmer in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-27-2019, 12:24 PM
  2. [SOLVED] Need help please with code to delete rows where a specified cell is blank
    By Grassman in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-12-2018, 10:03 AM
  3. [SOLVED] VB Code to delete blank rows
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-11-2017, 03:26 PM
  4. [SOLVED] VBA code to delete rows that are blank
    By cinstanl in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-08-2016, 02:35 PM
  5. [SOLVED] VB Code to copy and delete blank rows
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-04-2016, 12:28 AM
  6. Changing code from deleting rows to cut/paste rows into another sheet and delete blank row
    By kmarshall6576 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-18-2013, 01:54 AM
  7. Code to delete all blank rows and add totals
    By fusion007 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-24-2011, 04:00 PM

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