Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
How to find non-blank cell values "hidden" under merged regions? | Excel Discussion (Misc queries) | |||
If A3=alpha numeric,"X", if A3=text,"Y", Blank | Excel Worksheet Functions | |||
Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) | |||
Changing "returned" values from "0" to "blank" | Excel Worksheet Functions |