The "Next Cell" command in a "For Each ___ In ___" loop

Is there any way to make the "Next Cell" command go down instead of to the right?

Hello favoritepsalm1,

Excel stores the cells in a range first by column then by row. The For Each Loop follows the default storage method. You would need to use 2 loops if you want to examine all rows in the current column before going to the next column.

Dim Rng  As Range

  Set Rng = Range("A1:D50")

    For C = 1 To 4
      For R = 1 to 50
        X = Cells(R, C).Value
      Next R
   Next C

Sincerely,
Leith Ross