+ Reply to Thread
Results 1 to 5 of 5

Overflow Error, can't find the problem.

  1. 08-26-2016, 09:54 AM #1
    Scalpel4
    Scalpel4 is offline
    Registered User
    Join Date
    12-10-2013
    Location
    dallas, tx
    MS-Off Ver
    Excel 2007
    Posts
    36

    Overflow Error, can't find the problem.

    I'm getting Overflow error when I debug this. I can't find the problem. Anyone care to help? Thanks in advance for helping out this noob.

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 08-26-2016, 10:05 AM #2
    Norie
    Norie is offline
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Overflow Error, can't find the problem.

    Where do you get the error?
    If posting code please use code tags, see here.
    Reply With QuoteRegister To Reply
  3. 08-26-2016, 10:24 AM #3
    Scalpel4
    Scalpel4 is offline
    Registered User
    Join Date
    12-10-2013
    Location
    dallas, tx
    MS-Off Ver
    Excel 2007
    Posts
    36

    Re: Overflow Error, can't find the problem.

    For i = 1 To SourceRange.Count
    Reply With QuoteRegister To Reply
  4. 08-26-2016, 10:32 AM #4
    joeu2004
    joeu2004 is offline
    Forum Expert
    Join Date
    05-01-2014
    Location
    California, US
    MS-Off Ver
    Excel 2010
    Posts
    1,795

    Re: Overflow Error, can't find the problem.

    Quote Originally Posted by Scalpel4 View Post
    I'm getting Overflow error when I debug this.
    [....]
    Please Login or Register  to view this content.
    Change that to:

    i as Long
    Last edited by joeu2004; 08-26-2016 at 10:33 AM. Reason: cosmetic
    Reply With QuoteRegister To Reply
  5. 08-26-2016, 11:07 AM #5
    Scalpel4
    Scalpel4 is offline
    Registered User
    Join Date
    12-10-2013
    Location
    dallas, tx
    MS-Off Ver
    Excel 2007
    Posts
    36

    Re: Overflow Error, can't find the problem.

    That did it joeu2004, thanks!
    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)

Similar Threads

  1. Error 6: Overflow problem
    By smaier69 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-28-2014, 03:07 PM
  2. Run Time Error '6' Overflow - Macro That Find Text and Copy Range & Replace on Other Sheet
    By asgharhussaini in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-17-2013, 04:34 AM
  3. Explanation of the Run-time error '6': Overflow Error
    By mgphill in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-25-2012, 10:46 AM
  4. Want to do a while-loop but get error message: run error '6' overflow
    By danzi in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-07-2011, 01:48 PM
  5. Multi column find within a range and overflow error
    By brl8 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-09-2010, 03:20 PM
  6. Overflow Problem
    By jshinevar in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-25-2008, 06:00 AM
  7. Problem with overflow
    By Peter in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-02-2005, 06:20 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1