Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Jul 2005
    Location
    Earth, New Jersey, USA
    Posts
    53
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Delete if cell is empty (2002)

    Could someone provide some assitance. The attached code is suppose to delete a row if there's an empty cell in column K:K , unfortunately this is not taking place. Thanks in advance for any assistance you can provide.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Delete if cell is empty (2002)

    1) Remove the 'On Error Resume Next' to see if an error occurs.
    2) Try Range("K:K") instead of Columns("K:K")
    3) ActiveSheet.UsedRange is meaningless - you don't do anything with the range.

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Delete if cell is empty (2002)

    Are the cells really empty, or do they contain blanks or non-display characters, or a formula that results in a null string? SpecialCells(xlCellTypeBlanks) does not consider any of those to be empty.
    Legare Coleman

  4. #4
    Star Lounger
    Join Date
    Jul 2005
    Location
    Earth, New Jersey, USA
    Posts
    53
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Delete if cell is empty (2002)

    The cells are actually empty.

  5. #5
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Delete if cell is empty (2002)

    Could you post the workbook (altering any confidential data) that shows the problem?
    Legare Coleman

Posting Permissions

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