Cell to be truly blank, not "" or O

[David P.]

I need the Go To / Special / Blanks to be able to "Go to" the cells that are
blank.

The cells I'm trying to "go to" I thought we're blank but I guess since the
cell's result is "" (or what I thought was "blank") it is not picking those
up as blank.

Any suggestions?

 

[Sheeloo]

Cell can be truly blank if you go to the cell and delete whatever is there.
If it has a formula then it will not be treated as blank

 

[Jon Peltier]

We have repeatedly asked Microsoft to give us a worksheet function like
BLANK() or NULL() that a formula could return to be treated as a blank. So
far...nada.

- Jon

 

[Max]

I use this sub (by Jay) to clear cells with residual zero length null
strings: "" within a selected range. Just select the range, then run the sub.

Sub ClearNulls()
Set rng = Selection
For Each ar In Selection.Areas
For Each itm In ar
If Trim(itm.Value) = "" _
Then itm.ClearContents
Next 'itm
Next 'ar
End Sub

--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:370 Subscribers:66
xdemechanik

 

[David P.]

Thank you everyone. I racked my brain and came up with this and it worked so
that Go To picked up the cells as blank after running the code:

Columns("A:A").Select
Selection.Replace What:="0", Replacement:="", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Selection.SpecialCells(xlCellTypeBlanks).Select