Run Time Error 6: Overflow

[rosiemac]

Hi,

I have received a Run Time Error when executing some code. The code tries to define a new row
e.g.
rowa= rowb+1
rowb=rowa+1
The code is part of a loop and works fine until it reaches row 32763.
The runtime error suggests that excel has run out of rows. When I click Debug, the "rowb = rowa+1" is highlighted.

I thought excel had 65000+ rows. Indeed on the same worksheet that is causing me problems, I can navigate down to 65000 rows without any problem.

Any thoughts on what is causing this problem?

Thank you in advance.

 

[HippoCampus]

Hi Rosie

I found this when I had a similar problem,

You must declare "x" as a long data type.
For example:

Dim x as integer
x = len(longstring) 'Longstring is a string over 32,768 characters in
length


Would cause an overflow error

Dim x as long
x = len(longstring) 'Longstring is a string over 32,768 characters in
length

Would work


The integer data type only allows values from -32,768 to 32,768. More
or less than that and you get an overflow error.

 

[rosiemac]

Oh, gosh, feeling stupid now. I knew this!

Thank you for reminding me!