hi
in vb help, type "data type".
interger - 2 bytes = -32768 to 32767
your values = 23468 and 32933
32933 exceeds the value of and interger. that is your overflow problem.
change from interger to long if no decimal, double or single if decimal. see
data type in vb help.

regards
FSt1

"Phuelgod" wrote:

Hello folks,

I've got a runtime error 6 on the following line of code:

For k = 2 To j

local values a
k = 23468
j = 32933

both are declared integers

In a nutshell, the code find out how many rows of data there are, then goes
through each row to count the data by type (Select Case Left(Cells(k,2),2)).

Is there a limit to iterations on a for...next loop?

Any help troubleshooting this will be appreciated

Thanks!

Frank