| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is "" the same as NULL?
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hyperion Essbase Excel Add-in - returning text ("0") for null valu | Excel Discussion (Misc queries) | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Null, "null", vbNull, vbNullString, vbEmpty | Excel Programming | |||
| cells formatted to tick when text value "Y" if or null if "N" | Excel Discussion (Misc queries) | |||
| "IF"- "THEN" type Formula based on Null value | Excel Worksheet Functions | |||
![Dean@ERYC[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
