Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: arctan in vba

  1. #1
    Board Regular
    Join Date
    May 2010
    Posts
    143
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question arctan in vba

    Code:
    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?

  2. #2
    Board Regular
    Join Date
    Jan 2010
    Location
    MN, USA
    Posts
    454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: arctan in vba

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

    http://msdn.microsoft.com/en-us/libr...ffice.11).aspx

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

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
This website uses cookies
We use cookies to store session information to facilitate remembering your login information, to allow you to save website preferences, to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners.
     


DMCA.com