arctan in vba

[carstenp]

Az = Application.WorksheetFunction.Atan(Application.WorksheetFunction.Radians(((Abs(N_0 - N_1)) / (Abs(E_0 - E_1)))))

When I try to run this I get a runtime error 438. It's probably something pretty simple that I am just blanking on. any ideas or suggestions?

 

[ChrisOswald]

Unless I'm mistaken, WorksheetFunction.Atan() isn't included by MicroSoft in its list of available functions...

http://msdn.microsoft.com/en-us/library/aa221655(v=office.11).aspx

Fortunately, VBA has it's own function Atn().