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.

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

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



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

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

Cheers, Dean.

"Tom Ogilvy" wrote:

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



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