+ Reply to Thread
Results 1 to 5 of 5

run-time error 6: Overflow

  1. #1
    Forum Contributor
    Join Date
    07-22-2013
    Location
    Sibiu
    MS-Off Ver
    Excel 2007
    Posts
    114

    run-time error 6: Overflow

    Hey guys, my code is used to calculate a price. When it does not find something the errorhandler is assigning a "-" to the cell.
    I have 2 questions:
    1. Why do I get that error on the bolded line.
    2. Why is it not handled by the errorhandler?!?
    Thank you for the support.


    Please Login or Register  to view this content.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: run-time error 6: Overflow

    You would get the error if stfc was 0, the reason it isn't caught by the error handler could be because you haven't reset the error handler.
    If posting code please use code tags, see here.

  3. #3
    Forum Contributor
    Join Date
    07-22-2013
    Location
    Sibiu
    MS-Off Ver
    Excel 2007
    Posts
    114

    Re: run-time error 6: Overflow

    Could you please give me a tip on how do I reset the error handler?

  4. #4
    Forum Contributor
    Join Date
    07-22-2013
    Location
    Sibiu
    MS-Off Ver
    Excel 2007
    Posts
    114

    Re: run-time error 6: Overflow

    Nevermind I figured it out. Thank you so much for the quick response.

  5. #5
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: run-time error 6: Overflow

    Perhaps
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Run time error '6' , Overflow
    By PrashantS87 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-26-2015, 03:33 AM
  2. Run-time error 6: overflow
    By onmyway in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-02-2015, 06:24 AM
  3. Run-time error '6': Overflow HELP!
    By Nils88 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-14-2013, 06:46 AM
  4. [SOLVED] Run-time error '6': Overflow
    By msawyer in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-14-2012, 01:29 PM
  5. Run-time error '6': Overflow
    By magoobee in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-16-2006, 12:54 PM

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