Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    May 2003
    Location
    N. Andover, Massachusetts, USA
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Macro/ Blank Cell, delete row (Excel 2000)

    Hi,
    I need a macro which if run will looks in a specified column for a blank cell and if found will delete the entire row which contains the blank. Said another way in a sheet of data in 500 (1 to 500) rows and 30 columns (A to AD) it would delete any row which has a blank in row C. Any help would be greatly appreciated. Thank-you.

  2. #2
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Macro/ Blank Cell, delete row (Excel 2000)

    What you need to do is to consult the TagPanel <UL><LI>put square brackets [ ] around "post #164207" <LI> put an = directly after the #<LI>take out the space between "post" and the #.[/list]HTH
    Gre

  3. #3
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Trenton, Ontario
    Posts
    175
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Macro/ Blank Cell, delete row (Excel 2000)

    <P ID="edit" class=small>(Edited by Stats on 11-Jun-03 12:00. Added working link, thanks unkamunka!!)</P>Have a look at <post#=164207>post 164207</post#> by HansV. (Sorry, I don't know how to make a link to that page.)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •