Which is faster: For-loop or For Each-loop with integer?

I often find posts about how using the For Each-loop tends to be faster then using the For-loop.
But what if I need an incremental integer? Then which loop is faster?
I couldn't find it on Google so I thought I asked around here ;-)
I mean to use it with Arrays.

So when I need an incremental integer, which Loop is faster?
This one:

Please Login or Register  to view this content.

or this one:

Please Login or Register  to view this content.

Really? Didn't expect that, thanks!

Depends on what you are looping through. There is a good review at excelmacromastery.com/vba-for-loop

Originally Posted by Corbett

Depends on what you are looping through. There is a good review at excelmacromastery.com/vba-for-loop

I'll look into that, thanks!

Originally Posted by macropod

Hint: Don't declare numbers as Integer - declare them as Long. With VBA, numbers declared as Integer undergo a Long conversion, which adds processing overhead. See: https://docs.microsoft.com/en-us/pre...6(v=office.10)

Good point! At work we are using Excel 2013 though, so does it apply to that version too....?

Originally Posted by macropod

It applies to VBA generally.

Got it. I'll be off replacing all my Integers with Longs then
Thanks for the heads up!

thanks!

Originally Posted by macropod

Less typing, too!

Hahaha true!!