Is there a Formula that return blank cell ?

B

BrianB

Well-known Member

Joined

Feb 17, 2003

Messages

8,127

• May 26, 2005

• #2

does not treat that cell as completely blank.

Click to expand...

Not sure what you mean by this. What are you trying to do ?
If you want to refer to the new cell value you only need to have a formula like you already use eg. =IF(B1="", ....

 

Upvote 0

M

mrchonginhk

Well-known Member

Joined

Dec 3, 2004

Messages

679

• May 26, 2005

• #3

Actually this sheet will be used by IT to upload to another software.
That software detected that cell is not blank and thus error comes up.

Actually you can see it is not blank as well.

Copy a cell that has formula =""
paste as value to cell C1.
Then type something in B1 that is long enough to go through the length to C1. Then you will see a difference. Real blank cell should not block the text you key in in cell B1. But now it does.

Help !!

 

Upvote 0

M

mrchonginhk

Well-known Member

Joined

Dec 3, 2004

Messages

679

• May 26, 2005

• #4

Is there a better formula then ="" ?? so that when we copy that cell as value to another sheet, the corresponding cell is really blank cell ?

=NULL ??

 

Upvote 0

M

mrchonginhk

Well-known Member

Joined

Dec 3, 2004

Messages

679

• May 26, 2005

• #5

No way out ?

 

Upvote 0

M

mrchonginhk

Well-known Member

Joined

Dec 3, 2004

Messages

679

• May 26, 2005

• #6

HELP !!

 

Upvote 0

B

BrianB

Well-known Member

Joined

Feb 17, 2003

Messages

8,127

• May 26, 2005

• #7

Must really take our hats off to IT people, they way they keep us programmers in work !

Try something like this :-

Code:

Sub test()
    Dim MyRange As Range
    Application.Calculation = xlCalculationManual
    Set MyRange = ActiveSheet.Range("A1:Z100")
    For Each c In MyRange.Cells
        If c.Value = "" Then
            c.ClearContents
        End If
    Next
    Application.Calculation = xlCalculationAutomatic
    MsgBox ("Done")
End Sub

 

Upvote 0