Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dates and Recomended Graphing Programs to work with excel? | Charts and Charting in Excel | |||
A search for $ in a formula use to work now it does not work | Excel Discussion (Misc queries) | |||
Moving a sheet from one work book to another? | Excel Worksheet Functions | |||
My links no longer work . . . | Excel Discussion (Misc queries) | |||
How to get saved old saved work that was saved over? | Excel Discussion (Misc queries) |