+ Reply to Thread
Results 1 to 10 of 10

Overflow error

  1. 10-26-2010, 09:55 AM #1
    share knowledge is offline
    Registered User
    Join Date
    08-02-2008
    Location
    India
    Posts
    88

    Smile Overflow error

    Hi All

    I am getting error message ‘run time 6 - overflow while running the below code. I have highlighted the one where exactly the error is coming. I tried several times in new sheet, restarting my system... everything that I can 

    Please help me fixing this. 


    Please Login or Register  to view this content.
    Last edited by share knowledge; 11-02-2010 at 02:08 AM. Reason: change tags to code tags
    Reply With QuoteRegister To Reply
  2. 10-26-2010, 10:01 AM #2
    JBeaucaire is offline
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Overflow error

    Edit that post above and put code tags around your code before your thread gets closed for breaking the forum rules. Best hurry.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)
    Reply With QuoteRegister To Reply
  3. 10-29-2010, 06:42 AM #3
    share knowledge is offline
    Registered User
    Join Date
    08-02-2008
    Location
    India
    Posts
    88

    Re: Overflow error

    Hi

    I guess I have used the tags correctly for the coding.

    Do you guys have any idea about this error.
    Reply With QuoteRegister To Reply
  4. 10-29-2010, 06:59 AM #4
    romperstomper is offline
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,997

    Re: Overflow error

    You hadn't actually - you need to use CODE tags, not QUOTE tags. I have added them for you this time, but please learn to do it in future.

    I can't see anything immediately obvious there, but you could try splitting the test up:
    Please Login or Register  to view this content.
    Everyone who confuses correlation and causation ends up dead.
    Reply With QuoteRegister To Reply
  5. 10-29-2010, 07:00 AM #5
    Andy Pope is offline
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,482

    Re: Overflow error

    you need to post example workbook that produces the error as the code itself is fine.
    Cheers
    Andy
    www.andypope.info
    Reply With QuoteRegister To Reply
  6. 11-01-2010, 11:24 AM #6
    share knowledge is offline
    Registered User
    Join Date
    08-02-2008
    Location
    India
    Posts
    88

    Re: Overflow error

    Here is the sample..

    i got headache with this code...

    Thanks everyone for your support in fixing this
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  7. 11-01-2010, 11:34 AM #7
    romperstomper is offline
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,997

    Re: Overflow error

    Change that line to:
    Please Login or Register  to view this content.
    or format column A as General. It's the date formatting in that column that is confusing things with some of your larger values.
    Reply With QuoteRegister To Reply
  8. 11-01-2010, 11:42 AM #8
    Alf is online now
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,784

    Re: Overflow error

    My bad, romperstomper gave correct answer.
    Last edited by Alf; 11-01-2010 at 12:03 PM.
    Reply With QuoteRegister To Reply
  9. 11-01-2010, 12:05 PM #9
    JBeaucaire is offline
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Overflow error

    If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
    Reply With QuoteRegister To Reply
  10. 11-02-2010, 02:07 AM #10
    share knowledge is offline
    Registered User
    Join Date
    08-02-2008
    Location
    India
    Posts
    88

    Re: Overflow error

    amazing... thanks people.. you all are great..
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1