Have your function return a variant

Function myFunc(arg1 as ...) as Variant
'some code here
myFunc = CVErr(xlErrValue)
end function



Smallweed wrote:

I have a UDF which, if it can't find what it's looking for, I want to return
and show #VALUE in the cell. Any ideas how do I do this? Thanks.

--

Dave Peterson