ExcelBanter - How to return #VALUE! from a UDF

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - How to return #VALUE! from a UDF (https://www.excelbanter.com/excel-programming/309770-how-return-value-udf.html)

Niklas

How to return #VALUE! from a UDF

Hi
How do I return the error #VALUE! from a user defiened function?
Regards
/Niklas

Norman Jones

How to return #VALUE! from a UDF

Hi Niklas,

Try:

MyFunction = CVErr(xlErrValue)

---
Regards,
Norman

"Niklas" wrote in message
...
Hi
How do I return the error #VALUE! from a user defiened function?
Regards
/Niklas

All times are GMT +1. The time now is 11:58 PM.