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

Thread: Blank Cells

  1. #1
    Guest

    Default

    I am using the IF worksheet function. If the logical test produces a value of 0, I'd like the value_if_true to be a blank cell so I could go back later and do an Edit, GoTo, Special, Blanks and delete the rows that contain blanks. I've tried making the value_if_true to be "" and that makes the cell appear blank, but the GoTo procedure described above doesn't recognize the cell as blank. Any ideas on what value_if_true Excel would recognize as a true blank cell?

  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

    Can't be done using an Excel worksheet function. All functions MUST return something.

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Perth Australia
    Posts
    1,584
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi
    If you are going to delete the records anyway, try having your formula return "^" instead of zero or "". If ^ is a character that you don't normally use you can then change them to blank cells via the Replace function (ie in the find-what box put ^ and put nothing at all in the replace-with-what box). You can then use Edit, GoTo, Blanks the way you wanted to
    Just a thought
    regards
    Derek
    ps ^ is the character above the 6 on your keyboard

    [ This Message was edited by: Derek on 2002-03-08 08:47 ]

  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

    If you are going to delete the records anyway...
    Why not just return #N/A and use Edit | Go To... Special... Formulas (and leave only the Errors box checked)?

    [ This Message was edited by: Mark W. on 2002-03-08 08:54 ]

  5. #5
    Guest

    Default

    Thank you for the replies - returning a unique character then replacing it with a blank or returning an error value and doing a GoTo error both accomplish my goal - thanks!

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
  •