VBA to Delete empty rows in excel

  • This is too fast...!!!!
    Thanks a lot Dreamboat... it works!!!!!


    But i have another file that needs to check two columns if empty (i mean, column A is empty, but Column C is not and vice versa). I want to delete the rows if both Column A and C are empty. How can I do that?


    Thank you in advance... I really do appreciate your help!

  • We're working on creating code that'll do it for whatever column(s) are selected.


    But try this for your columns A & C:



    I did not test, and I'll be going out for a few hours...

  • To to it manually use the Autofilter-function by:


    1) Select the startcell for the list in the left upper corner.
    2) Choose the command Data | Filter | Autofilter.
    3) In column A select the option Empty from the drop down arrow.
    4) Repeat step 3 for column C.


    The only visible rows should now be only those that meet these two conditions.


    [Edit]
    Since the title of this message imply use of VBA pls check out the following post: http://ozgrid.com/forum/showthread.php?t=20029


    Especially #4.

  • You guys are supercalifragilisticexpialidocious!!!!


    I thing I have missed 2/3 of my professional carreer by not visiting this site before. I'm sure I have missed so many things out here. Is there a way to search for a specific topic (thread)? Is there a list of topics by category (let's say Filtering, Conditional Formatting, etc) where i can just simply click and view all the threads.


    My sincerest thanks for your help!!!


    More power to this site!!!!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!