Vbanullstring, empty, ""

[mahmed1]

Hi can anyone explain what is refered to as a 0 value, blank value "" and empty value i.e nothing in that cell.

I have seen scenarios where people say null string or empty string, or empty but not empty "".

Can anyone please explain which is what and it referes to in vba/excel

Thank you

 

[circledchicken]

Hi,

This might help:
http://www.mrexcel.com/forum/showthread.php?t=42495

 

[mahmed1]

Hi,

So if im getting right

A nullstring or vbanull string is
"" or 0 value
Is nothing in vba referes to a 0 or blank value
Isblank on a spreadsheet is if the cell has nothing
Totally empty
Isempty in vba is the same thing

 

[mahmed1]

Hi,

So if im getting right

A nullstring or vbanull string is
"" or 0 value
Is nothing in vba referes to a 0 or blank value
Isblank on a spreadsheet is if the cell has nothing
Totally empty
Isempty in vba is the same thing

Is that correct?

 

[shg]

No.

vbNullString is a compiler constant that refers to a zero-length string. A cells with a formula that returns a null string ("") has the same value as vbNullString.

Empty is the state of an uninitialized Variant, or one that is explicity set to Empty. IsEmpty(Range("A1").Value) or VarType(Range("A1").Value) = vbEmpty tests whether a cell is empty, equivalent to =IsBlank(A1) from the UI. Empty means just that -- no formula, no null string, de nada.

VBA performs lots of type conversions, so Range("A1").Value = vbNullString returns True if A1 is empty only because Empty converted to a string is a null string.

 

[mahmed1]

No.

vbNullString is a compiler constant that refers to a zero-length string. A cells with a formula that returns a null string ("") has the same value as vbNullString.

Empty is the state of an uninitialized Variant, or one that is explicity set to Empty. IsEmpty(Range("A1").Value) or VarType(Range("A1").Value) = vbEmpty tests whether a cell is empty, equivalent to =IsBlank(A1) from the UI. Empty means just that -- no formula, no null string, de nada.

VBA performs lots of type conversions, so Range("A1").Value = vbNullString returns True if A1 is empty only because Empty converted to a string is a null string.

AAAAHHHH now that makes sense.

So VBNullString is "" however it also sets it to true if is genuinely empty or blank.

I can also check to see if the cell is empty (no "") by using isempty which will ignore ""?

One last one (what is Nothing) referred to in VBA?

Thank YOu

 

[shg]

Nothing is the value of an uninitialized object variable, or one that has been explicitly set to Nothing.