+ Reply to Thread
Results 1 to 5 of 5

Bug: Evaluate function with numbers is erratic

  1. #1
    Registered User
    Join Date
    08-31-2012
    Location
    Rio, Brazil
    MS-Off Ver
    Excel 2003
    Posts
    11

    Bug: Evaluate function with numbers is erratic

    My Excel is 2003 SP 3 (Windows XP).
    I've found a very crazy stuff!

    I use Ctrl+G (Immediate Window)
    Please Login or Register  to view this content.
    All lines above generate error

    Please Login or Register  to view this content.
    All lines above are OK


    Why? Is it a known Excel 2003 bug?

    I've googled
    "evaluate(2)" "excel" "vba" "function" "bug"
    and I didn't found nothing similar!

  2. #2
    Forum Expert Jakobshavn's Avatar
    Join Date
    08-17-2012
    Location
    Lakehurst, NJ, USA
    MS-Off Ver
    Excel 2007
    Posts
    1,970

    Re: Bug: Evaluate function with numbers is erratic

    I just tried:

    Please Login or Register  to view this content.
    and saw no problems
    Gary's Student

  3. #3
    Registered User
    Join Date
    08-31-2012
    Location
    Rio, Brazil
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: Bug: Evaluate function with numbers is erratic

    Thanks for your answer.
    It is good that the bug has been resolved in the latest versions
    Maybe this error is specific to Excel 2003.
    Note that my version is the last official version from Excel 2003 (Service Pack 3)

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Bug: Evaluate function with numbers is erratic

    They all work equally well for me in Excel 2003.
    Entia non sunt multiplicanda sine necessitate

  5. #5
    Registered User
    Join Date
    08-31-2012
    Location
    Rio, Brazil
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: Bug: Evaluate function with numbers is erratic

    You don't will believe me, but shg is absolutely right and I'm right too.
    I restart Excel and this weird problem disappears. For a while.
    However, when I've opened my worksheet, the Evaluate problem has returned.
    So I start to search where the problem arises.
    Finally I've discovered that erasing one button that points to a supplement. XLA, the problem was over.
    At last, I create other button calling the same procedure in XLA and everything is OK.
    Amazing ...

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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