With a user defined function saved in an *.xla add-in...
How can I make the function return the worksheet error value #N/A?

as an example (that doesn't work)

Function MyFunction(x,y, optional z)
MyFunction = application.worksheetfunction.NA()
End Function

On Fri, 21 Oct 2005 18:41:02 -0700, KAHAUS
wrote:

With a user defined function saved in an *.xla add-in...
How can I make the function return the worksheet error value #N/A?

as an example (that doesn't work)

Function MyFunction(x,y, optional z)
MyFunction = application.worksheetfunction.NA()
End Function

Function foo()
foo = CVErr(xlErrNA)
End Function


--ron

something like:

Option Explicit
Function MyFunction(x, y, Optional z) As Variant
If IsMissing(z) Then
MyFunction = CVErr(xlErrNA)
Else
MyFunction = z
End If
End Function




KAHAUS wrote:

With a user defined function saved in an *.xla add-in...
How can I make the function return the worksheet error value #N/A?

as an example (that doesn't work)

Function MyFunction(x,y, optional z)
MyFunction = application.worksheetfunction.NA()
End Function

--

Dave Peterson

Both Ron & Dave: Thanks, works great! Ive been searching for CVErr for days!

"Dave Peterson" wrote:

something like:

Option Explicit
Function MyFunction(x, y, Optional z) As Variant
If IsMissing(z) Then
MyFunction = CVErr(xlErrNA)
Else
MyFunction = z
End If
End Function




KAHAUS wrote:

With a user defined function saved in an *.xla add-in...
How can I make the function return the worksheet error value #N/A?

as an example (that doesn't work)

Function MyFunction(x,y, optional z)
MyFunction = application.worksheetfunction.NA()
End Function

--

Dave Peterson