CONVERTING AN EMPTY TEXT BACK TO BEING BLANK
 

My problem is with converting an empty text back to a blank cell. "" IS NOT A
BLANK CELL BUT AN EMPTY TEXT.if a cell is "" then isblank will be false

CONVERTING AN EMPTY TEXT BACK TO BEING BLANK
 

Select the cells that may have the "" in them and use

Dim myCell As Range
For Each myCell In Selection
If myCell.Value = "" Then myCell.Value = ""
Next myCell


Note that this will remove formulas that return "" You could use this to prevent deleting
formulas:

Dim myCell As Range
For Each myCell In Selection
If Not myCell.HasFormula Then
If myCell.Value = "" Then myCell.Value = ""
End If
Next myCell

HTH,
Bernie
MS Excel MVP


"excel guru" <excel wrote in message
...
My problem is with converting an empty text back to a blank cell. "" IS NOT A
BLANK CELL BUT AN EMPTY TEXT.if a cell is "" then isblank will be false