Hello Frank

The problem is your variable type.

Integer variables can only hold values from -32,768 to 32,767. Define the
varibles as Long, as it can hold values up to 2,147,483,647

Regards,
Per

"Phuelgod" skrev i meddelelsen
...
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