Have you tried declaring as LONG. Take a look at the HELP files for INTEGER
and LONG
--
HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.



"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