Use

VBA includes its own SIN,COS and TAN , but doesn't include ASIN,ACOS and ATAN , so you need to use"

Application.Asin( )

or

Application.WorksheetFunction.Asin( )

HTH,
Bernie
MS Excel MVP


"subash" wrote in message
...
I have written a module(function) to use it as a user defined function by
creating a macro
When I use excel trignometric functions like SIN,COS and TAN the function is
getting executed whreas when functions like ASIN,ACOS and ATAN are used in
the module, I get compilation error
I am struggling to get a link
can any one help please?