"" 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

Dean@ERYC wrote:
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.