+ Reply to Thread
Results 1 to 4 of 4

VB Code to delete Blank Rows

  1. 07-15-2020, 09:38 AM #1
    rizmomin
    rizmomin is offline
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    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
    Reply With QuoteRegister To Reply
  2. 07-15-2020, 09:46 AM #2
    TMS
    TMS is online now
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,375

    Re: VB Code to delete Blank Rows

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

    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

    Reply With QuoteRegister To Reply
  3. 07-15-2020, 09:54 AM #3
    rizmomin
    rizmomin is offline
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Re: VB Code to delete Blank Rows

    Hello

    Thanks TMS.

    Below code works great thanks

    Please Login or Register  to view this content.
    Riz
    Reply With QuoteRegister To Reply
  4. 07-15-2020, 11:11 AM #4
    TMS
    TMS is online now
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,375

    Re: VB Code to delete Blank Rows

    You're welcome. Thanks for the rep.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1