Johnny Rosenberg wrote:
Function MyFunction(A As Variant) As Variant
Dim Something As Variant
REM Lots of stuff here…
MyFunction=Something
End Function
Using it in a cell:
=MyFunction(A1)
So A should be the content of the cell A1 in this case. However, if A1
is empty, A ends up as a double with the value 0. This makes it quite
impossible to detect wether a cell is empty or not, doesn't it? At
least I can't find a way to do that.
Hi Johnny.
Hmmm.... that's strange. I could not find a straightforward way either.
Tried IsEmpty() and IsNull() but neither of them worked as expected.
That doesn't mean that there isn't a solution; only that I don't know one.
However, I found this workaround that might be acceptable:
Function MyFunction(A As Variant) As Variant
if A = "" then
MyFunction = Null
else
MyFunction = "Input is " + A
end if
End Function
and rewrite the cell function to be
=MYFUNCTION(IF(ISBLANK(A1);"";A1))
Should work if you can live with encoding Null as a blank string.
Thousands of Oracle DBA's, myself included, do that every day even
though it is silly.
Hope this helps.
Cheers
-- Jan Holst Jensen
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
