Why Does vbNull = 1

[biocentrism]

I have the formula below. But instead of inserting a Blank, it inserts the value of 1. Why is this and how can I insert a blank? I know I can use "", but I read somewhere that it is better to use vbNull instead of "". Am I doing something wrong?

cel.Value = vbNull

Furthermore, when used in other places vbNull can also return a value of -1 and 65535.

Anyone know what is going on here?

Thank you.

 

[mikerickson]

vbNullString is the alternative to ""

vbNull is a Variable Type constant. meaning that if one has a variable, x, vbNull is one of the possible values of VarType(x)

Dim x As Variant
x = Null
MsgBox VarType(x) = vbNull

 

[biocentrism]

Thank you. If I have a datatype = Double, how do I insert a blank?

I have tried =Nul and =Empty, but they all insert a value of some sort (usually 0).

 

[MARK858]

Deleted too slow

 

[shg]

cel.ClearContents

 

[biocentrism]

cel.ClearContents

Sometimes the simplest solution is that hardest to see! Thank you for your help!

 

[shg]

You're welcome.