How do I force my Excel/VBA function to return #N/A ?

[MigrantFirmWorker]

A typical error from the canned Excel functions is '#N/A'. I would like my function to do the same under appropriate conditions.

The Excel function NA() will return this value in the worksheet. I tried

return Application.WorksheetFunction.NA()

but VBA doesn't seem to recognize this one. Any ideas?

Chris

-------------------------------------------------------------
"Don't be deceived. We're all temporary employees.

 

[SkipVought]

Dim x
[A1] = "=NA()"
x = [A1]

Skip,

_{Did you hear what happened when the OO programmer lost his library?...
He's now living in OBJECT poverty!}

 

[MigrantFirmWorker]

Thanx. Do you know of any way to do it without having a dedicated cell in the workbook to generate the value/

Chris

-------------------------------------------------------------
"Don't be deceived. We're all temporary employees.

 

[SkipVought]

y = xlErrNA

Skip,

_{Did you hear what happened when the OO programmer lost his library?...
He's now living in OBJECT poverty!}

 

[MigrantFirmWorker]

Thanx.

Chris

-------------------------------------------------------------
"Don't be deceived. We're all temporary employees.