Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Won't Delete

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Los Angeles, CA
    Posts
    752
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have a formula in column J, because I want to delete blank rows I copy, paste special, values, column J, then run a delete empty row macro.

    The macro works fine.

    The problem is something remains in the blank cells of column J. This is the problem I know it.

    Any ideas or suggestions on how I can go around it or fix it???

    Thanks

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-19 16:05, Parra wrote:
    I have a formula in column J, because I want to delete blank rows I copy, paste special, values, column J, then run a delete empty row macro.

    The macro works fine.

    The problem is something remains in the blank cells of column J. This is the problem I know it.

    Any ideas or suggestions on how I can go around it or fix it???

    Thanks
    If your formula is something like...

    =IF(logical_test,value_if_true,"")

    ...that "remaining something" is a text string ("") with a length of zero. Just because you can't see it doesn't mean nothing is there! If a cell contains "" that cell is nonblank (not empty).

    [ This Message was edited by: Mark W. on 2002-04-19 16:10 ]

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Los Angeles, CA
    Posts
    752
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks for the explanation. The formula you put up is close to the formula I copied pasted.

    Any suggestions? On how to fix my problem.

    Thanks

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-19 16:21, Parra wrote:
    Thanks for the explanation. The formula you put up is close to the formula I copied pasted.

    Any suggestions? On how to fix my problem.

    Thanks
    You could select these cells, choose the Edit | Text to Columns... menu command, and press [ Finish ]. This will convert any cells containing "" into blank cells.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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