+ Reply to Thread
Results 1 to 5 of 5

Macro to delete every row which has blank fields in a column

  1. 03-03-2012, 07:09 AM #1
    nbardram
    nbardram is offline
    Registered User
    Join Date
    03-01-2012
    Location
    Copenhagen
    MS-Off Ver
    Excel 2010
    Posts
    12

    Macro to delete every row which has blank fields in a column

    Hi All,

    Can someone help me with a macro which deletes every row, when one of the columns contain blanks.

    Example attached.

    I would appreciate it. Thanks
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 03-03-2012, 07:24 AM #2
    JapanDave
    JapanDave is offline
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Re: Macro to delete every row which has blank fields in a column

    See if this does what you are after?
    Attached Files Attached Files
    Last edited by JapanDave; 03-03-2012 at 07:26 AM.
    Be fore warned, I regularly post drunk. So don't take offence (too much) to what I say.
    I am the real 'Napster'
    The Grid. A digital frontier. I tried to picture clusters of information as they moved through the computer. What did they look like? Ships? motorcycles? Were the circuits like freeways? I kept dreaming of a world I thought I'd never see. And then, one day...

    If you receive help please give thanks. Click the * in the bottom left hand corner.

    snb's VBA Help Files
    Reply With QuoteRegister To Reply
  3. 03-03-2012, 07:41 AM #3
    Marcol
    Marcol is offline
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,216

    Re: Macro to delete every row which has blank fields in a column

    Try this, adjust the range to suit your actual range, it will be faster on larger sheets than looping each row.
    Please Login or Register  to view this content.
    Last edited by Marcol; 03-03-2012 at 07:44 AM.
    If you need any more information, please feel free to ask.

    However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....

    Also
    اس کی مدد کرتا ہے اگر
    شکریہ کہنے کے لئے سٹار کلک کریں
    If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
    Reply With QuoteRegister To Reply
  4. 03-03-2012, 07:53 AM #4
    davesexcel
    davesexcel is offline
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,486

    Re: Macro to delete every row which has blank fields in a column

    try This
    Please Login or Register  to view this content.
    ,
    Xlorate.com, Selection Codes, YouYube Channel
    Reply With QuoteRegister To Reply
  5. 03-03-2012, 08:01 AM #5
    nbardram
    nbardram is offline
    Registered User
    Join Date
    03-01-2012
    Location
    Copenhagen
    MS-Off Ver
    Excel 2010
    Posts
    12

    Re: Macro to delete every row which has blank fields in a column

    Thanks to all of you for replying. I went with daves answer, it works perfectly and fast

    Have a nice weekend.
    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)

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