Is "" the same as NULL?

[Guest]

I am doing some data validation on some worksheets mainly looking for blank
fields using the formula: ActiveCell.FormulaR1C1 =
"=IF(RC[-1]="""",""ERROR"","""")"

Is "" the same as a NULL value (ie a blank cell)? As later validation using
a pivot table picks up the "" entries seperately from the [blanks] entries.

Is there a way to enter a NULL value instead of the "" value in the above
formula.

Cheers, Dean.

 

[Sandy]

"" is a "null" value, excel always puts a value to a cell ie. "" (zero
length string) for a blank cell in spreadsheets. In VBA the "null"
value is used for objects of the Variant type like an array.

HTH

Sandy

 

[Guest]

"" is a zero length string. It isn't blank because the cell has a formula in
it and it is returning a string.

There is no way in current versions to have a formula return a value that
makes the cell count as blank.

 

[Guest]

Thanks Tom - not the answer I was hoping for but ho hum life goes on !!

Cheers, Dean.

"" is a zero length string. It isn't blank because the cell has a formula in
it and it is returning a string.

There is no way in current versions to have a formula return a value that
makes the cell count as blank.

--
Regards,
Tom Ogilvy

I am doing some data validation on some worksheets mainly looking for blank
fields using the formula: ActiveCell.FormulaR1C1 =
"=IF(RC[-1]="""",""ERROR"","""")"

Is "" the same as a NULL value (ie a blank cell)? As later validation using
a pivot table picks up the "" entries seperately from the [blanks] entries.

Is there a way to enter a NULL value instead of the "" value in the above
formula.

Cheers, Dean.