How do I use the excel function ATAN in a module used in excel
 

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?

How do I use the excel function ATAN in a module used in excel
 

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?

How do I use the excel function ATAN in a module used in excel
 

As a side note, vba uses Atn( ) for ATAN.
For the op, if you click on vba help for Atn, you can also select "See
Also", and then select "Derived Math Functions." This will list some vba
solutions to Trig functions that are not included in vba.

- -
HTH. :)
Dana DeLouis
Windows XP, Office 2003


"Bernie Deitrick" <deitbe @ consumer dot org wrote in message
...
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?