Technical question: Order of for each-loops

[eviMogwai]

When you set up a for each-loop through a range, in what order will it chose cells?
In the case of rows/columns I hope it's from left to right and top to bottom respectively.
But how is it with other ranges, say 3x4 or 4x3?

function roulette(rRange As Range)
'rRange an arbitrary range
 
For Each cell In rRange
debug.print(cell.adress(false, false))
Next

 

[Ruddles]

I've only ever seen it in that order. However if order is crucial, then you should use a couple of nested loops to go through the rows, then within each row go through the columns.

 

[villy]

i think you can set for ...next for rows and columns respectively

 

[eviMogwai]

Indeed I could, but then i wouldn't learn anything new

There are some benefits to using the single for each ... next-loop with regards to memory usage and speed (from what I've gathered) but most of all I'd like to write this slightly more elegant solution (and not have to repeat a lot of code in the program I wrote it for)

 

[villy]

When you set up a for each-loop through a range, in what order will it chose cells?
In the case of rows/columns I hope it's from left to right and top to bottom respectively.
But how is it with other ranges, say 3x4 or 4x3?

Yes you're right it's left to right.. tried and tested..
see example..

sub chkpos()
 
for each c in range("A2:D10")
    msgbox c
next c
end sub

 

[eviMogwai]

Clever test, thank you!