OverFlow Error in For Loop

**Excel_Fan** · 08-09-2009, 01:33 PM

First-time poster here. I used to have a ton of experience with Java and C# but now my job calls for VB scripts in excel. Probably an assignment error or logic error but here's the code :

basically what im doing is i have two workbooks "New Dashboard" and "Book1". I search column A in Book1 for HELLO, and then i use the row it was found in to grab a value "HrsVal". I take that value and i put it "New Dashboard". I then do the same for every sheet. It seems to fail in my second loop in the 2nd sheet. Error says "Overflow".

Please Login or Register  to view this content.

Thanks

**Richard Schollar** · 08-09-2009, 01:51 PM

You get an overflow error most likely because the maximum value of a VBA Integer has been exceeded (+32,767). Try dimensioning RowNumber as a Long and see if this rectifies your problem.

Richard

**Excel_Fan** · 08-09-2009, 01:54 PM

Originally Posted by RichardSchollar

You get an overflow error most likely because the maximum value of a VBA Integer has been exceeded (+32,767). Try dimensioning RowNumber as a Long and see if this rectifies your problem.

Richard

I have 3 sheets, and the RowNumber values will be 13 in the first loop, 35 in the 2nd, and 14 in the 3rd (i have test sheets setup). I tried long. Still get the same OverFlow.

Thanks!

You're right... the value of HrsValue was over 32767... it was 70,000! Long fixed it. Thanks!

This is SOLVED. Is there a way to mark this solved?

**Richard Schollar** · 08-09-2009, 02:31 PM

If you double-click on the title bar when viewing the forum you should be able to amend the title to SOLVED: at the front (this is how the forum software works on another web forum I frequent - things may be different here though)

**Excel_Fan** · 08-09-2009, 04:35 PM

Originally Posted by RichardSchollar

If you double-click on the title bar when viewing the forum you should be able to amend the title to SOLVED: at the front (this is how the forum software works on another web forum I frequent - things may be different here though)

great. done. thanks!

**nikko50** · 01-28-2014, 02:43 PM

You are exactly correct. I changed to a Long and it works. You rock. Tracy

OverFlow Error in For Loop

LinkBack

Thread Tools

Rate This Thread

Display

OverFlow Error in For Loop

Re: OverFlow Error in For Loop

Re: OverFlow Error in For Loop

Re: OverFlow Error in For Loop

Re: OverFlow Error in For Loop

Re: OverFlow Error in For Loop

Thread Information

Users Browsing this Thread

Similar Threads

Explanation of the Run-time error '6': Overflow Error

Want to do a while-loop but get error message: run error '6' overflow

Msg error (overflow)

Overflow Error

Overflow error, need help

Bookmarks

Bookmarks

Posting Permissions