Blank Cells

[Guest]

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?

 

[Mark W.]

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

 

[Derek]

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

 

[Mark W.]

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

 

[Guest]

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!