Cell to be truly blank, not "" or O
 

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?
--
David P.

Cell to be truly blank, not "" or O
 

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

"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?
--
David P.

Cell to be truly blank, not "" or O
 

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
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Sheeloo" <="to" & CHAR(95) & "sheeloo" & CHAR(64) & "hotmail.com" wrote in
message ...
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

"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?
--
David P.

Cell to be truly blank, not "" or O
 

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?

Cell to be truly blank, not "" or O
 

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?