+ Reply to Thread
Results 1 to 4 of 4

I get a "sub or function not defined" compiler error when i try to use Degrees() function?

  1. #1
    Registered User
    Join Date
    04-02-2013
    Location
    Amman, Jordan
    MS-Off Ver
    Excel 2010
    Posts
    2

    I get a "sub or function not defined" compiler error when i try to use Degrees() function?

    Whenever i run the macro i get this error.. here's my code:


    Please Login or Register  to view this content.
    I get the same problem with the Radians() function. I'm using excel 2010.
    Last edited by waaayoff; 04-02-2013 at 08:37 AM.

  2. #2
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: I get a "sub or function not defined" compiler error when i try to use Degrees() funct

    Welcome to the forum. Pls take few minutes to read forum rules, because:

    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

    Posting code in tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Highlight your code and click the # icon at the top of your post window.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Registered User
    Join Date
    04-02-2013
    Location
    Amman, Jordan
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: I get a "sub or function not defined" compiler error when i try to use Degrees() funct

    There i fixed it

    Could really use an answer though

  4. #4
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: I get a "sub or function not defined" compiler error when i try to use Degrees() funct

    degrees is not a vba function so you need to access it via the worksheetfunction object
    Please Login or Register  to view this content.
    Josie

    if at first you don't succeed try doing it the way your wife told you to

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1