"Asin" doesn't work in VB for Excel macros

[Guest]

I get the error message "sub or function not defined" when I try to use ASIN
in VBA Excel. Works OK in the worksheet, asin gets changed to Asin when I
type it into VBA and Asin is listed as a function for VBA in the help but it
doesn't work?

 

[Dave Peterson]

Try application.asin()

Some worksheet functions have equivalent VBA functions. Some don't.

Some worksheet functions can be used in VBA (like this one).

 

[Guest]

try this:

application.worksheetfunction.asin(...)