I want to enlarge my 'for' limit

[bombapopsi]

Hey Guys!

I have a "semi-large" database, between 3000 and 10 000 rows, changes daily, in the future it may be around 12 000 lines.
My question: If i enlarge my for cycle like this:

for i = 2 To 10000 ---> For i = 2 To 15000

Will it make slower? My macro run? Mostly we work with ~6000 rows, but if it goes until 15k, i think thats not so good. Or is there any way? (There are empty rows between rows)

Thanks

[kaasplankje]

My guess is that it will get 50% slower ;-)
To see how much that will hurt, please provide your code.

[bombapopsi]

Yea i actually made it, to see it for myself, and it was ~1minute 10s before, and now its ~2min 25s, so yea, i got my answer :D

[kaasplankje]

That's pretty long.

[bombapopsi]

Yea, i have multiple for loops, basicially i use it in our warehouse, and i have multiple different product, so yea, i think thats why, but i can make it shorter if i add and extra 'If Cells(i,3) <> "" ', it made faster by ~0,5minute

[kaasplankje]

If you are happy then I am happy :-)

[vichopalacios]

@ bombapopsi

If you share your code here, by sure you will find a Guru, that can make it runs much, much faster