Can you change the order/pattern that vba uses to loop through a range?

So if i set a "for each cell in range" loop up with range A1 to ?# the loop checks cells in the order A1,B1,C1..?1,A2,B2,C2...?2...A#,B#,C#...?# is there a way to change the order to A1,A2,A3...A#,B1,B2,B3...B#...?1,?2,?3...?#
I am trying to get a macro to look for three in a three consecutive values in a row or column without having to write a unique loop for each row or column.