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

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?