+ Reply to Thread
Results 1 to 6 of 6

Delete blank rows after filter - if no blank rows exit sub

  1. #1
    Forum Contributor
    Join Date
    04-21-2009
    Location
    England
    MS-Off Ver
    Excel 2016
    Posts
    710

    Delete blank rows after filter - if no blank rows exit sub

    Hi all, just need some tweaking on a macro I have that delete's blank rows after a filter.

    The rows and in a table named "customer range", the macro works fine - unless there are no blank rows and then it delete's everything.

    Please Login or Register  to view this content.
    Teh filter checks for blanks in Column A (as all otehr rows should be populated in this column).

    Thanks in advance for your help

  2. #2
    Forum Contributor bonny24tycoon's Avatar
    Join Date
    04-02-2012
    Location
    Hell
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    405

    Re: Delete blank rows after filter - if no blank rows exit sub

    Hi Mate,

    Sorry posted the incorrect macro.. Will re-post in sometime. Apologies
    Last edited by bonny24tycoon; 06-27-2012 at 08:12 AM.
    Thanks,

    Bonny Tycoon


  3. #3
    Forum Contributor
    Join Date
    04-21-2009
    Location
    England
    MS-Off Ver
    Excel 2016
    Posts
    710

    Re: Delete blank rows after filter - if no blank rows exit sub

    Hi there, no i get a run time error 6 message saying "overflow" and highlighting the LastRow = Activesheet.............. part

  4. #4
    Forum Contributor bonny24tycoon's Avatar
    Join Date
    04-02-2012
    Location
    Hell
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    405

    Re: Delete blank rows after filter - if no blank rows exit sub

    Hi Mate,

    Apologies for the previous post.. Check this out


    Please Login or Register  to view this content.
    Last edited by bonny24tycoon; 06-27-2012 at 08:30 AM.

  5. #5
    Forum Contributor
    Join Date
    04-21-2009
    Location
    England
    MS-Off Ver
    Excel 2016
    Posts
    710

    Re: Delete blank rows after filter - if no blank rows exit sub

    Works a treat - thank you so much

  6. #6
    Forum Contributor bonny24tycoon's Avatar
    Join Date
    04-02-2012
    Location
    Hell
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    405

    Re: Delete blank rows after filter - if no blank rows exit sub

    Thats great. Im happy that I was able to help.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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