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

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

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

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