Use na() function in code?

[Guest]

Anyone know how to code the na() function in VBA and why the following doesn't work

Function test(
test = Application.WorksheetFunction.na(
End Functio

It does work if I type =na() directly into a cell..

Bruc

 

[Charles Williams]

Try

Test=CVERR(XlErrNa)


--
Charles
______________________
Decision Models
FastExcel Version 2 now available.
www.DecisionModels.com/FxlV2WhatsNew.htm