Use na() function in code?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Validation List (conditional) 2
Distinguishing 0 formatted as "na" and as 0 2
testing for #NA with VBA 2
How can I rewrite IF IsError Function to Work in VBA 1
Quadratic Polynomial fit with LINEST() 5
Enter NA() into All Blank Cells in Range 16
test for #NA , help please 2
find workbook names that are in sheet 9

Back
Top