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

--
David P.


"Max" wrote:

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." wrote:
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?