Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to? UDF returning nothing
Greetings!
Have a function doing a conversion on a target cell. If the target cell is empty (literally: IsEmpty), then I'd like for the function to return nothing, such that the destination cell value is also empty (not a blank or empty string, which is something). No return (not setting a function value), and a return of Null, both result in the number 0. Ideas? Thanks, George |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to? UDF returning nothing
Functions, whether built-in or UDFs, return values to cells.
Additionally, if there's a formula in the cell, it's not empty, and won't be evaluated as empty by IsEmpty(), regardless of what it returns. If you truly want the cell to be empty, you'll have to replace the function with an event macro. In article , "G Lykos" wrote: Have a function doing a conversion on a target cell. If the target cell is empty (literally: IsEmpty), then I'd like for the function to return nothing, such that the destination cell value is also empty (not a blank or empty string, which is something). No return (not setting a function value), and a return of Null, both result in the number 0. Ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Returning the value | Excel Discussion (Misc queries) | |||
Returning a zero | Excel Discussion (Misc queries) | |||
UDF not returning anything | Excel Discussion (Misc queries) | |||
Sum returning 0 | Excel Worksheet Functions | |||
UDF Returning #N/A | Excel Programming |