why does atan2 not work??
 

i would like to use atan2(x,y) in my program but i get an error: "Sub or
function not defined". i try to use atn but it yeild the wrong result.

why does atan2 not work??
 

ATAN2 is not a VBA function -- it is an Excel function.
Therefore, you have to call it via Application.WorksheetFunction.
E.g.,

res = Application.WorksheetFunction.Atan2(x, y)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"jaison" wrote in message
...
i would like to use atan2(x,y) in my program but i get an error:
"Sub or
function not defined". i try to use atn but it yeild the wrong
result.

why does atan2 not work??
 

Also, do remember computer work with angles in radians not degrees
See Help for functions RADIANS and DEGREES
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"jaison" wrote in message
...
i would like to use atan2(x,y) in my program but i get an error: "Sub or
function not defined". i try to use atn but it yeild the wrong result.