How to cause a #num! error

[Ken Kazinski]

Hi,

Is there a way to have a function return a error message? I would like one
of my functions to return a #num! error when the range passed to it is empty.

Thanks,

Ken

[Andrew Taylor]

Function ReturnsHashNum()
ReturnsHashNum = CVErr(xlErrNum)
End Function

There are other error consts if you need them- xlErrNA.
xlErrDiv0, etc

Andrew



Ken Kazinski wrote:
> Hi,
>
> Is there a way to have a function return a error message? I would like one
> of my functions to return a #num! error when the range passed to it is empty.
>
> Thanks,
>
> Ken

[Ken Kazinski]

Thanks that gave an error in the cell - just not a num error.

[Dave Peterson]

It returned #NUM! for me.

What did you get?

Ken Kazinski wrote:
>
> Thanks that gave an error in the cell - just not a num error.

--

Dave Peterson